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