Postgres Pro
Downloads
Home   >   mailing lists

Re: more voodoo planner bs :) - Mailing list pgsql-novice

From Tom Lane
Subject Re: more voodoo planner bs :)
Date
Msg-id 29168.1020833058@sss.pgh.pa.us
Whole thread Raw
In response to more voodoo planner bs :)  ("D. Duccini" <duccini@backpack.com>)
List pgsql-novice
Tree view 
"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

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Relation does not exist
Next
From: Sharon Cowling
Date:
Subject: Incorrect Query