Re: Optimizer improvements: to do or not to do?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Optimizer improvements: to do or not to do?
Дата
Msg-id 15790.1158070606@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Optimizer improvements: to do or not to do?  (Gregory Stark <stark@enterprisedb.com>)
Список pgsql-hackers
Gregory Stark <stark@enterprisedb.com> writes:
> It's possible there's some sort of "block-wise correlated" measure
> which would be even better for our needs.

Actually, it seems obvious to me that the correlation measure ought to
ignore within-block ordering, but right now it does not.  OTOH it's not
clear how important that is, as on a decent-size table you'll probably
not have more than one sample row in a block anyway.
        regards, tom lane


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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: Optimizer improvements: to do or not to do?
Следующее
От: Naz Gassiep
Дата:
Сообщение: Re: dump / restore functionality