Re: more voodoo planner bs :)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "D(dot) Duccini" <duccini(at)backpack(dot)com>
Cc: Pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: more voodoo planner bs :)
Date: 2002-05-08 04:44:18
Message-ID: 29168.1020833058@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"D. Duccini" <duccini(at)backpack(dot)com> writes:
> Can anyone tell me why the planner is penalizing me for changing ONE
> value?

I'm guessing that one or the other value matches the "most common value"
recorded in pg_statistic?

I'm also betting you are not on 7.2. Older versions have coarser
statistics that are more likely to make foolish decisions for
not-quite-the-most-common values ...

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Sharon Cowling 2002-05-08 05:06:00 Incorrect Query
Previous Message Tom Lane 2002-05-08 04:08:30 Re: Relation does not exist