> 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

Reply via email to