Re: Slow planning time when public schema included (12 vs. 9.4)

Поиск
Список
Период
Сортировка
От Anders Steinlein
Тема Re: Slow planning time when public schema included (12 vs. 9.4)
Дата
Msg-id CAC35HN=DOxkRKq8aPPnxVfcutxOTggZdgmzZ6TdFEJ7gvj6O6g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Slow planning time when public schema included (12 vs. 9.4)  (Andreas Kretschmer <andreas@a-kretschmer.de>)
Список pgsql-performance
Дерево обсуждения
On Sat, Mar 21, 2020 at 2:37 PM Andreas Kretschmer <andreas@a-kretschmer.de> wrote:


Am 21.03.20 um 13:02 schrieb Anders Steinlein:
> default_statistics_target = 1000

not sure if this be the culprit here, but i think this is way too high.
Leave it at the normal value of 100 and raise it only for particular
tables and columns.

It may very well be too high, but the 9.4 instance also has default_statistics_target = 1000.

Best,
-- a.

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Slow planning time when public schema included (12 vs. 9.4)
Следующее
От: Anders Steinlein
Дата:
Сообщение: Re: Slow planning time when public schema included (12 vs. 9.4)