Re: more voodoo planner bs :)

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: "D. Duccini" <duccini@backpack.com>
Cc: Pgsql-novice <pgsql-novice@postgresql.org>
Date: 2002-05-08T04:44:18Z
Lists: pgsql-novice
"D. Duccini" <duccini@backpack.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