Re: BUG #16109: Postgres planning time is high across version -10.6 vs 10.10

Поиск
Список
Период
Сортировка
От Mukesh Chhatani
Тема Re: BUG #16109: Postgres planning time is high across version -10.6 vs 10.10
Дата
Msg-id 1573670250461-0.post@n3.nabble.com
обсуждение исходный текст
Ответ на BUG #16109: Postgres planning time is high across version - 10.6 vs 10.10  (PG Bug reporting form <noreply@postgresql.org>)
Ответы Re: BUG #16109: Postgres planning time is high across version - 10.6vs 10.10  (Andres Freund <andres@anarazel.de>)
Список pgsql-bugs
Дерево обсуждения 
All,

Update I was able to resolve the problem by changing - partitioned tables to
single table and changing data type of 2 columns used in the joins from
varchar to varchar(50).

FYI.. default_statistics_target was set to 10000 but I changed it 100 and
even to 1000 and still planning time was high.

Still working on the dataset so that more people can investigate the issues.



--
Sent from: https://www.postgresql-archive.org/PostgreSQL-bugs-f2117394.html

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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: [BUG] Uninitializaed configOut.leafType used.
Следующее
От: Andres Freund
Дата:
Сообщение: Re: BUG #16109: Postgres planning time is high across version - 10.6vs 10.10