Josh Berkus <j...@agliodbs.com> writes:
> I'm getting something really odd in 9.2.4, where the planner estimates
> that the selectivity of a column equal to itself is always exactly 0.5%
> (i.e. 0.005X). I can't figure out where this constant is coming from,
> or why it's being applied.
See DEFAULT_EQ_SEL. But why exactly do you care? Surely it's a stupid
query and you should fix it.
regards, tom lane
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
