Re: PostgreSQL 11 higher Planning time on Partitioned table

Поиск
Список
Период
Сортировка
От Justin Pryzby
Тема Re: PostgreSQL 11 higher Planning time on Partitioned table
Дата
Msg-id 20200223104609.GA27688@telsasoft.com
обсуждение исходный текст
Ответ на Re: PostgreSQL 11 higher Planning time on Partitioned table  (Justin Pryzby <pryzby@telsasoft.com>)
Список pgsql-performance
Дерево обсуждения 
On Sun, Feb 23, 2020 at 04:12:09AM -0600, Justin Pryzby wrote:
> How large are the partitions and how many indexes each, and how large are they?
> Each partition will be stat()ed ... for every query.

I should have said that's every 1GB "segment" is stat()ed for every query.

> This was resolved in pg12:
> https://commitfest.postgresql.org/21/1778/

+ https://www.postgresql.org/about/featurematrix/detail/320/

-- 
Justin

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

Предыдущее
От: Justin Pryzby
Дата:
Сообщение: Re: PostgreSQL 11 higher Planning time on Partitioned table
Следующее
От: Ravi Garg
Дата:
Сообщение: Re: PostgreSQL 11 higher Planning time on Partitioned table