Re: Bug in query planer ?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Bug in query planer ?
Дата
Msg-id 1839.1138814395@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Bug in query planer ?  (Clifford Wolf <clifford.wolf@linbit.com>)
Ответы Re: Bug in query planer ?  (Clifford Wolf <clifford.wolf@linbit.com>)
Список pgsql-bugs
Clifford Wolf <clifford.wolf@linbit.com> writes:
> However, it would be great to have get_restriction_variable() and
> get_attstatsslot() extended so they can pass the most common values
> from the statistics cache thru expressions, as described in my earlier
> mail.

This would only be helpful if the most-common-values list describes
practically all of the column population, which isn't typically the case.

In any case I'm not sure why you're resistant to maintaining an index
on an expression that you are frequently querying by --- that index
could have more direct use than just cueing ANALYZE what to figure
statistics on.

            regards, tom lane

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

Предыдущее
От: Clifford Wolf
Дата:
Сообщение: Re: Bug in query planer ?
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Huge number of disk writes after migration to 8.1