Re: [HACKERS] Postgres code for a query intermediate dataset

2014-09-14 Thread Rohit Goyal
wood < mark.kirkw...@catalyst.net.nz> wrote: > On 14/09/14 20:11, Rohit Goyal wrote: > >> Hi Mark, >> >> On Sun, Sep 14, 2014 at 8:57 AM, Mark Kirkwood >> mailto:mark.kirkw...@catalyst.net.nz>> >> wrote: >> > > Currently in Postgres, these

Re: [HACKERS] Postgres code for a query intermediate dataset

2014-09-14 Thread Rohit Goyal
Hi Mark, On Sun, Sep 14, 2014 at 8:57 AM, Mark Kirkwood < mark.kirkw...@catalyst.net.nz> wrote: > On 14/09/14 05:36, Rohit Goyal wrote: > >> Hi All, >> >> I want to work on the code of intermediate dataset of select and update >> query. >> >> For

[HACKERS] Postgres code for a query intermediate dataset

2014-09-13 Thread Rohit Goyal
erent versions of the data. I want to know the code portion which i need to look for working on all 4 versions in dataset. :) Thanks in advance!! Regards, Rohit Goyal -- Regards, Rohit Goyal

Re: [HACKERS] Least Active Transaction ID function

2014-07-24 Thread Rohit Goyal
Hi Robert, On Thu, Jul 24, 2014 at 9:32 PM, Robert Haas wrote: > On Wed, Jul 23, 2014 at 3:53 PM, Rohit Goyal wrote: > > Hi All, > > > > On Wed, Jul 23, 2014 at 5:01 PM, Rohit Goyal > wrote: > >> > >> Hi All, > >> > >> I am doing

Re: [HACKERS] Least Active Transaction ID function

2014-07-23 Thread Rohit Goyal
Hi All, On Wed, Jul 23, 2014 at 5:01 PM, Rohit Goyal wrote: > Hi All, > > I am doing programming with postgresql source code. I want to find out the > function which can give me Least active transaction id currenty in the > system. > > Is there any function which can give

[HACKERS] Least Active Transaction ID function

2014-07-23 Thread Rohit Goyal
Hi All, I am doing programming with postgresql source code. I want to find out the function which can give me Least active transaction id currenty in the system. Is there any function which can give me that? Regards, Rohit Goyal

Re: [HACKERS] Shared Data Structure b/w clients

2014-07-22 Thread Rohit Goyal
Hi Atri/All, I am very new in postgresql code. Can you please help in a bit detail ortel me how to create structure in shared memory(shared buffer). It would be really easy for me if you can give me a code snippet or any link to follow. Regards, Rohit Goyal On Tue, Jul 22, 2014 at 8:30 PM

[HACKERS] Shared Data Structure b/w clients

2014-07-22 Thread Rohit Goyal
one session/terminal. Please tel me how postgresql do that and how i can do that? Regards, Rohit Goyal

Re: [HACKERS] Error in running DBT2

2014-05-20 Thread Rohit Goyal
On Tue, May 20, 2014 at 9:57 AM, Andrew Dunstan wrote: > > On 05/20/2014 03:39 AM, Rohit Goyal wrote: > >> Hi All, >> >> Just adding the actual error again. >> >> I run the the *dbt2-pgsql-build-db -w 1 * >> >> >> Output directory of data

Re: [HACKERS] Error in running DBT2

2014-05-20 Thread Rohit Goyal
* *CONTEXT: COPY item, line 1* *ROLLBACK* This pattern the above found many times. Please guide me through!!! Regards, Rohit Goyal On Tue, May 20, 2014 at 9:15 AM, Rohit Goyal wrote: > Hi All, > > > > On Tue, May 13, 2014 at 9:44 PM, Peter Geoghegan wrote: > >> >>

Re: [HACKERS] Error in running DBT2

2014-05-20 Thread Rohit Goyal
Hi All, On Tue, May 13, 2014 at 9:44 PM, Peter Geoghegan wrote: > > On Tue, May 13, 2014 at 12:36 PM, Rohit Goyal wrote: > >> This pattern the above found many times. Please guide me through!!! >> > > IIRC, people have been working around this by setting > stand

[HACKERS] Error in running DBT2

2014-05-15 Thread Rohit Goyal
): File "/tmp/dbt2/bin/dbt2-post-process", line 14, in import rpy2.robjects as robjects ImportError: No module named rpy2.robjects Test completed. Results are in: /tmp/result Please guide me !! :) Regards, Rohit Goyal -- Regards, Rohit Goyal

Re: [HACKERS] Error in running DBT2

2014-05-15 Thread Rohit Goyal
pected operator* > */home/abhi/dbt2_install/bin/dbt2-pgsql-load-stored-procs: 53: [: c: > unexpected operator* > *unknown stored function type: c* > > and script ends!! > > moreover, I see that DB has been created and also 9 tables are there in > Database dbt2. Please suggest

Re: [HACKERS] Error in running DBT2

2014-05-14 Thread Rohit Goyal
-load-stored-procs: 53: [: c: unexpected operator* *unknown stored function type: c* and script ends!! moreover, I see that DB has been created and also 9 tables are there in Database dbt2. Please suggest how to proceed. Regards, rohit Goyal On Tue, May 13, 2014 at 9:44 PM, Peter Geoghegan wrote

Re: [HACKERS] Error in running DBT2

2014-05-13 Thread Rohit Goyal
Hi Peter, On Tue, May 13, 2014 at 9:44 PM, Peter Geoghegan wrote: > > On Tue, May 13, 2014 at 12:36 PM, Rohit Goyal wrote: > >> This pattern the above found many times. Please guide me through!!! >> > > IIRC, people have been working around this by setting > stand

[HACKERS] Error in running DBT2

2014-05-13 Thread Rohit Goyal
encoding "UTF8": 0xf9* *CONTEXT: COPY item, line 1* *ROLLBACK* This pattern the above found many times. Please guide me through!!! Regards, Rohit Goyal

[HACKERS] Running DBT2 on postgresql

2014-05-12 Thread Rohit Goyal
meter before installation. Regards, Rohit Goyal -- Regards, Rohit Goyal

Re: [HACKERS] Runing DBT2 on Postgresql

2014-05-12 Thread Rohit Goyal
On Thu, Apr 24, 2014 at 6:57 AM, Peter Geoghegan wrote: > On Wed, Apr 23, 2014 at 2:33 AM, Rohit Goyal wrote: > > I am trying to install dbt2 on postgresql database. > > > > cmake(configure) command work fine and but make command(build) give an > error > > given b

Re: [HACKERS] Runing DBT2 on Postgresql

2014-04-24 Thread Rohit Goyal
Hi Everyone, Sorry, i got this now. :) Regards, Rohit Goyal On Thu, Apr 24, 2014 at 4:24 PM, Rohit Goyal wrote: > Hi Peter/All, > > Can you please elaborate a bit in details the steps? where are how to run > these steps? > > Regards, > Rohit Goyal > > > On Thu,

Re: [HACKERS] Runing DBT2 on Postgresql

2014-04-24 Thread Rohit Goyal
Hi Peter/All, Can you please elaborate a bit in details the steps? where are how to run these steps? Regards, Rohit Goyal On Thu, Apr 24, 2014 at 6:57 AM, Peter Geoghegan wrote: > On Wed, Apr 23, 2014 at 2:33 AM, Rohit Goyal wrote: > > I am trying to install dbt2 on postgresql

[HACKERS] Runing DBT2 on Postgresql

2014-04-23 Thread Rohit Goyal
bpq/dbc_common.c:49: undefined reference to `PQfinish' CMakeFiles/bin/dbt2-client.dir/src/libpq/dbc_common.o: In function `_disconnect_from_db': /home/abhi/project/dbt2/src/libpq/dbc_common.c:58: undefined reference to `PQfinish' Please guide me through !! Regards, Rohit Goyal

Re: [HACKERS] HOT Update || want to use a different page for updated tuple

2014-04-04 Thread Rohit Goyal
On Fri, Apr 4, 2014 at 2:03 PM, Heikki Linnakangas wrote: > On 04/04/2014 02:53 PM, Rohit Goyal wrote: > >> Hi All, >> >> I was comparing postgresql performance and was just curious about >> performance in case i want to store the updated index tuple version on

[HACKERS] HOT Update || want to use a different page for updated tuple

2014-04-04 Thread Rohit Goyal
for updated index tuple version. Please guide me, about how i can achieve this. Regards, Rohit Goyal

[HACKERS] Disable hot-update functionality

2014-03-05 Thread Rohit Goyal
Hi All, Is there any ways by which i can disable the hot-update functionality? -- Regards, Rohit Goyal

Re: [HACKERS] Fwd: Request for error explaination || Adding a new integer in indextupleData Structure

2014-01-28 Thread Rohit Goyal
format is > now different. > > Cheers, > > Jeff > Hi Jeff and Tom, Thanks you so much. I was making the mistake you mentioned in the last mail. :) Regards, Rohit Goyal -- Regards, Rohit Goyal

Re: [HACKERS] Fwd: Request for error explaination || Adding a new integer in indextupleData Structure

2014-01-28 Thread Rohit Goyal
> > Rohit Goyal writes: >> > Hi All, >> > I was trying to modify indextupledata structure by adding an integer >> > variable. ButI faced an error message "psql: FATAL: could not find >> tuple >> > for opclass 10032". >> >> &g

[HACKERS] Fwd: Request for error explaination || Adding a new integer in indextupleData Structure

2014-01-27 Thread Rohit Goyal
Hi All, I was trying to modify indextupledata structure by adding an integer variable. ButI faced an error message "psql: FATAL: could not find tuple for opclass 10032". Could anyone please help me in resolving this issue. Regards, Rohit Goyal -- Regards, Rohit Goyal

Re: [HACKERS] Call flow of btinsert(PG_FUNCTION_ARGS)

2013-11-19 Thread Rohit Goyal
On Tue, Nov 19, 2013 at 11:52 AM, Craig Ringer wrote: > On 11/19/2013 06:22 PM, Rohit Goyal wrote: > > Hi All, > > > > I was reading b tree index code and I wanted to the know the calling > > function which calls btinsert > > < > http:

Re: [HACKERS] Call flow of btinsert(PG_FUNCTION_ARGS)

2013-11-19 Thread Rohit Goyal
On Tue, Nov 19, 2013 at 11:26 AM, Peter Geoghegan wrote: > On Tue, Nov 19, 2013 at 2:22 AM, Rohit Goyal wrote: > > > > I was reading b tree index code and I wanted to the know the calling > > function which calls btinsert(PG_FUNCTION_ARGS) function in nbtree.c > fil

[HACKERS] Call flow of btinsert(PG_FUNCTION_ARGS)

2013-11-19 Thread Rohit Goyal
function in nbtree.c file. Moreover, my goal behind reading this function was to check how tuple is inserted in btree. I want to understand the code flow for b tree index Please help!! -- Regards, Rohit Goyal

[HACKERS] Compile and test in netbeans

2013-11-17 Thread Rohit Goyal
using printf(). -- Regards, Rohit Goyal

Re: [HACKERS] Information about Access methods

2013-11-13 Thread Rohit Goyal
On Wed, Nov 13, 2013 at 2:42 AM, Craig Ringer wrote: > On 11/13/2013 06:36 AM, Rohit Goyal wrote: > > Hi, > > Thanks for document. It was really helpful. > > Now, as index folder contains basically interface for all index type, do > > I need to change it, if I want

Re: [HACKERS] Information about Access methods

2013-11-12 Thread Rohit Goyal
confirm. :) Regards, Rohit On Tue, Nov 12, 2013 at 1:22 PM, Craig Ringer wrote: > On 11/12/2013 07:00 PM, Rohit Goyal wrote: > > > > Inside access methods in Backend, I found "Index" folder and "Btree" > > folder but i don't know which code to look

[HACKERS] Information about Access methods

2013-11-12 Thread Rohit Goyal
hange something in B tree implementation. Please guide. Regards, Rohit Goyal

Re: [HACKERS] Fwd: Test of Algorithm || Indexing Scheme

2013-11-11 Thread Rohit Goyal
please elaborate ur opinion in detail. It would be of a great help to me. Regards, Rohit On Mon, Nov 11, 2013 at 6:16 PM, Rohit Goyal wrote: > Hi, > Can you pls tel me how can achieve which sound pretty exotic to you. > > Can u please share some relevant documents. I havw no clue f

Re: [HACKERS] Fwd: Test of Algorithm || Indexing Scheme

2013-11-11 Thread Rohit Goyal
Hi, Can you pls tel me how can achieve which sound pretty exotic to you. Can u please share some relevant documents. I havw no clue from where to start. Regards Rohit On 11.11.2013 14:12, Rohit Goyal wrote: > Hi, > Thanks for reply. > I actually want to make some changes in all oper

Re: [HACKERS] Fwd: Test of Algorithm || Indexing Scheme

2013-11-11 Thread Rohit Goyal
use my algorithm as GiST opclass. I dont have much knowledge abt this also? Regards, Rohit Goyal On Mon, Nov 11, 2013 at 12:31 PM, Heikki Linnakangas < hlinnakan...@vmware.com> wrote: > On 11.11.2013 13:19, Rohit Goyal wrote: > >> Hi All, >> >> I want to implement

[HACKERS] Fwd: Test of Algorithm || Indexing Scheme

2013-11-11 Thread Rohit Goyal
. Regards, Rohit Goyal