[HACKERS] Total memory allocated to postgres

2010-10-08 Thread vamsi krishna
Hi I want to know how much main memory is actually allocated to be the maximum memory for postgresql, because my hardware may have 4GB main memory but at the end of the day, only 1GB may be allocated for postgres. I want to set (increase) it manually. Can someone tell me how to do it? In aset.c

[HACKERS] Estimation of Plan quality

2010-08-31 Thread vamsi krishna
Dear all Can someone tell me how to estimate the quality of my plan. For example if the ideal query plan generated by Dynamic Programming has a plan quality of 1.0, and suppose I generate my query plan with some greedy method or something, it will be worse (not as optimal as) than ideal plan by,

[HACKERS] Measuring execution time

2010-08-10 Thread vamsi krishna
Hello all I want to measure the execution time spent running an SQL select query after the plan generation. So precisely I want to put my start timer before createQueryDesc() or ExecutorStart() and end timer after freeQueryDesc() or ExecutorEnd(). Right now I did so in "spi.c", "explain.c", "pqu

[HACKERS] Copy path in Dynamic programming

2010-07-22 Thread vamsi krishna
Hi everybody I am doing a modification to Dynamic programming algorithm in postgreSQL. I want to re-use a plan of one " joinrels" for another of the same level. For example, if lev=5 , and let's say there are two combinations setA = {1,2,3,4,5} and set B={6,7,8,9,10}. I want to reuse the plan of

[HACKERS] need help

2005-06-03 Thread vamsi krishna
hi, i want to know how CREATE table (creating a relation) works in Postgres.where can i find this in source code. also i want to know how postgres parser the input(create table) and how is this connected to the create table source code files.

Re: [HACKERS] Permissions within a function

2004-12-17 Thread vamsi krishna
forward to hear from you. Vamsi Krishna Kundeti On Fri, 17 Dec 2004 20:12:30 +0100, Thomas Hallgren <[EMAIL PROTECTED]> wrote: > I'd like some views on the following issue. > > The pljava function call handler will resolve a class name using a > loader that in turn uses