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

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

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

2013-11-11 Thread Rohit Goyal
to 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 and test my indexing approach. I would

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 operations

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 rhtgyl...@gmail.com 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

[HACKERS] Information about Access methods

2013-11-12 Thread Rohit Goyal
implementation. Please guide. Regards, Rohit Goyal

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 cr...@2ndquadrant.com 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 for. i want to change something

Re: [HACKERS] Information about Access methods

2013-11-13 Thread Rohit Goyal
On Wed, Nov 13, 2013 at 2:42 AM, Craig Ringer cr...@2ndquadrant.com 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 to modify only b

[HACKERS] Compile and test in netbeans

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

[HACKERS] Call flow of btinsert(PG_FUNCTION_ARGS)

2013-11-19 Thread Rohit Goyal
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

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 p...@heroku.com wrote: On Tue, Nov 19, 2013 at 2:22 AM, Rohit Goyal rhtgyl...@gmail.com 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 file

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 cr...@2ndquadrant.comwrote: 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://doxygen.postgresql.org/nbtree_8c.html

[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] Fwd: Request for error explaination || Adding a new integer in indextupleData Structure

2014-01-28 Thread Rohit Goyal
Rohit Goyal rhtgyl...@gmail.com 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. Could anyone please help me in resolving this issue. You broke a system

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

2014-01-28 Thread Rohit Goyal
. :) Regards, Rohit Goyal -- 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

[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

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 hlinnakan...@vmware.comwrote: 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 a different page. I

[HACKERS] Runing DBT2 on Postgresql

2014-04-23 Thread Rohit Goyal
/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] 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 p...@heroku.com wrote: On Wed, Apr 23, 2014 at 2:33 AM, Rohit Goyal rhtgyl...@gmail.com wrote: I am trying to install

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 rhtgyl...@gmail.com 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, Apr 24, 2014 at 6:57

Re: [HACKERS] Runing DBT2 on Postgresql

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

[HACKERS] Running DBT2 on postgresql

2014-05-12 Thread Rohit Goyal
Goyal -- Regards, Rohit Goyal

[HACKERS] Error in running DBT2

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

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 p...@heroku.com wrote: On Tue, May 13, 2014 at 12:36 PM, Rohit Goyal rhtgyl...@gmail.com wrote: This pattern the above found many times. Please guide me through!!! IIRC, people have been working around this by setting

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 p

Re: [HACKERS] Error in running DBT2

2014-05-15 Thread Rohit Goyal
* */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 how to proceed. Regards, rohit Goyal On Tue

[HACKERS] Error in running DBT2

2014-05-15 Thread Rohit Goyal
): File /tmp/dbt2/bin/dbt2-post-process, line 14, in module 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-20 Thread Rohit Goyal
Hi All, On Tue, May 13, 2014 at 9:44 PM, Peter Geoghegan p...@heroku.com wrote: On Tue, May 13, 2014 at 12:36 PM, Rohit Goyal rhtgyl...@gmail.com wrote: This pattern the above found many times. Please guide me through!!! IIRC, people have been working around this by setting

Re: [HACKERS] Error in running DBT2

2014-05-20 Thread Rohit Goyal
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 rhtgyl...@gmail.com wrote: Hi All, On Tue, May 13, 2014 at 9:44 PM, Peter Geoghegan p...@heroku.com wrote: On Tue, May 13, 2014

Re: [HACKERS] Error in running DBT2

2014-05-20 Thread Rohit Goyal
On Tue, May 20, 2014 at 9:57 AM, Andrew Dunstan and...@dunslane.net 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 files: current directory *Generating data files for 1

[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] 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] 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] Least Active Transaction ID function

2014-07-23 Thread Rohit Goyal
Hi All, On Wed, Jul 23, 2014 at 5:01 PM, Rohit Goyal rhtgyl...@gmail.com 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 me

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 robertmh...@gmail.com wrote: On Wed, Jul 23, 2014 at 3:53 PM, Rohit Goyal rhtgyl...@gmail.com wrote: Hi All, On Wed, Jul 23, 2014 at 5:01 PM, Rohit Goyal rhtgyl...@gmail.com wrote: Hi All, I am doing programming

[HACKERS] Postgres code for a query intermediate dataset

2014-09-13 Thread Rohit Goyal
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] 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 example. Rohit's salary has been updated 4 times, so it has 4

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

2014-09-14 Thread Rohit Goyal
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 mark.kirkw...@catalyst.net.nz mailto:mark.kirkw...@catalyst.net.nz wrote: Currently in Postgres, these intermediate versions all exist - however a given