> However, I wondered if we couldn't mitigate this by caching the results
> of constraint exclusion analysis for a particular table + condition. I
> have no idea how hard this would be, but in principle it seems silly to
> keep paying the same penalty over and over again.
This would be a perfect candidate for the plan-branch based on actual
parameters capability, in association with globally cached plans
mentioned here:
http://archives.postgresql.org/pgsql-hackers/2008-04/msg00920.php
Cheers,
Csaba.
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
No comments:
Post a Comment