Heikki Linnakangas <[EMAIL PROTECTED]> writes:
> You're right, I haven't, but yes I know that's a problem. We've chatted
> about that with Greg sometimes. It would be nice to have more stable
> plans. My favorite idea is to stop using the current relation size in
> the planner, and use the value snapshotted at ANALYZE instead.
Sorry, that's a nonstarter. We used to act that way and it was
completely fatal to plan quality in very many typical scenarios.
IMHO, the only thing worse than an unstable plan is a stable one.
regards, tom lane
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
