| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com> |
| Cc: | "Heikki Linnakangas" <heikki(dot)linnakangas(at)enterprisedb(dot)com>, "Grzegorz Jaskiewicz" <gj(at)pointblue(dot)com(dot)pl>, "Pg Hackers" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Simple postgresql.conf wizard |
| Date: | 2008-11-14 17:07:47 |
| Message-ID: | 28784.1226682467@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
"Jonah H. Harris" <jonah(dot)harris(at)gmail(dot)com> writes:
> On Fri, Nov 14, 2008 at 11:43 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> IMHO, the only thing worse than an unstable plan is a stable one.
> Your opinion contradicts the majority of the industry then, I'm
> afraid. Like query hints, people are sometimes smarter than the
> optimizer.
And, very often, they're not --- or more likely, they were smarter than
the optimizer last year, but now conditions have changed. Failing to
adapt to new conditions is exactly the problem with query hints, and
in general with any insistence that plans should be "stable".
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Meskes | 2008-11-14 17:11:41 | pgsql: Enable script to generate preproc.y in build process. |
| Previous Message | Simon Riggs | 2008-11-14 17:07:34 | Re: Synchronous replication patch v2 |