[BUGS] 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,

[BUGS] 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

[BUGS] DETAIL: Failed on request of size 8

2010-07-22 Thread vamsi krishna
Hi I am running a query on postgres and got the following error: ERROR: out of memory DETAIL: Failed on request of size 8 Can somebody help? Thanks