[HACKERS] functions to obtain query plan

2007-04-21 Thread sharath kumar
Hello For a particular query, are there any functions which can give me the start-up cost, total run-cost, number of rows and width? Thanks, Sharat.

Re: [HACKERS] schema creation during initdb

2007-04-18 Thread sharath kumar
nd, the above schema and table should be created automatically. Thanks, Sharat. On 4/18/07, Andrew Dunstan <[EMAIL PROTECTED]> wrote: sharath kumar wrote: > How can I create a schema during initdb time? > For example pg_catalog, pg_toast, information_schema are created > during initdb

[HACKERS] schema creation during initdb

2007-04-17 Thread sharath kumar
How can I create a schema during initdb time? For example pg_catalog, pg_toast, information_schema are created during initdb time. Likewise I want to create my own schema at initdb time. How can i do it? Also how to create a table into this schema at that time itself? Thanks Sharat.

[HACKERS] need help in understanding gist function

2007-03-14 Thread sharath kumar
I need help in understanding certain things in gist ... 1. What is the functionality of gistplacetopage() function in gist.c ?Can you please give me detail description of this function. 2. I have left and right buffers with values that I have filled. Now, how do I write these changes(buffers) perm

[HACKERS] user-defined tree methods in GIST

2007-03-06 Thread sharath kumar
I need some help in building new index structure using GIST. I have to include a procedure for restructuring the tree immediately after i have created the index using gist. How do i do it? Actually I am trying to implement the slim-tree index using gist. To increase the performance, a slim-down al