Re: [PERFORM] CREATE STATISTICS and join selectivity

Поиск
Список
Период
Сортировка
От David Rowley
Тема Re: [PERFORM] CREATE STATISTICS and join selectivity
Дата
Msg-id CAKJS1f-6B7KnDFrh6SFhYn-YbHYOXmDDAfd0XC=jJKZMCrfQyg@mail.gmail.com
обсуждение исходный текст
Ответ на [PERFORM] CREATE STATISTICS and join selectivity  (Justin Pryzby <pryzby@telsasoft.com>)
Список pgsql-performance
On 16 November 2017 at 09:19, Justin Pryzby <pryzby@telsasoft.com> wrote:
> I just noticed that PG10 CREATE STATISTICS (dependencies) doesn't seem to work
> for joins on multiple columns; is that right?

Unfortunately, for now, they're not used for join selectivity
estimates, only for the base rel selectivities. That's all there was
time for with PG10. This is highly likely to be improved sometime in
the future.

-- David Rowley                   http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training & Services


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

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

Предыдущее
От: Justin Pryzby
Дата:
Сообщение: [PERFORM] CREATE STATISTICS and join selectivity
Следующее
От: Neto pr
Дата:
Сообщение: [PERFORM] POWA doesn't show queries executed