Re: Simple postgresql.conf wizard - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Simple postgresql.conf wizard
Date
Msg-id 28223.1226680995@sss.pgh.pa.us
Whole thread Raw
In response to Re: Simple postgresql.conf wizard  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Responses Re: Simple postgresql.conf wizard  ("Jonah H. Harris" <jonah.harris@gmail.com>)
List pgsql-hackers
Heikki Linnakangas <heikki.linnakangas@enterprisedb.com> 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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: CREATE AGGREGATE disallows STYPE = internal
Next
From: "Jonah H. Harris"
Date:
Subject: Re: Simple postgresql.conf wizard