Re: benchmarking the query planner

Поиск
Список
Период
Сортировка
От Vladimir Sitnikov
Тема Re: benchmarking the query planner
Дата
Msg-id 1d709ecc0812111354m2f5a7ba5gebc9e1d50b9de913@mail.gmail.com
обсуждение исходный текст
Ответ на Re: benchmarking the query planner  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: benchmarking the query planner  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers

I think that would likely be redundant with the histogram.
I am afraid I do not get you. I mean histograms should be considered when it comes to increasing number of MCV entries (at least for numeric/timestamp values). With histogram lower number of entries could be sufficient to get reasonable accuracy of estimations.
I have no idea how to decide between automatic switch between histograms and MCV. It might sound crazy one could compute both histograms and MCV and use them both (and pick an average of two estimations :) )

Regards,
Vladimir Sitnikov

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

Предыдущее
От: "Nathan Boley"
Дата:
Сообщение: Re: benchmarking the query planner
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: benchmarking the query planner