Re: Weird, bad 0.5% selectivity estimate for a column equal to itself

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Weird, bad 0.5% selectivity estimate for a column equal to itself
Дата
Msg-id 25930.1371850378@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Weird, bad 0.5% selectivity estimate for a column equal to itself  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-performance
Josh Berkus <josh@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


В списке pgsql-performance по дате отправления:

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Weird, bad 0.5% selectivity estimate for a column equal to itself
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: Weird, bad 0.5% selectivity estimate for a column equal to itself