> It sounds like you're proposing to compare the time spent planning to > the estimated execution time. AFAICS, those things are unrelated, so > I'm not sure what you hope to figure out by comparing them.
The idea is: If we are to spend a LOT of resources executing the query, we might as well burn some cycles in hope of finding a better plan. > It sounds like you may have some concrete queries that suffer from > this problem. It might be helpful to post the queries and the good > and bad plans. It may be that the problem can be fixed with some > tuning of the existing parameters. Actually, no. This is my random thought based on observing some threads where people get bad plans due to GEQO. > The deadline for the final CommitFest was November 1st, so I think it > is too late for 8.4. ugh.. too bad. I`m still interested anyway :) Marcin -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers