Josh Berkus <josh@xxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance