Re: Slow planning, fast execution for particular 3-table query

Поиск
Список
Период
Сортировка
От Michael Lewis
Тема Re: Slow planning, fast execution for particular 3-table query
Дата
Msg-id CAHOFxGpJSCGjTaHsZ-kJu0JOBhAAR-V1MEFRyi-WTSomvCXaXA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Slow planning, fast execution for particular 3-table query  (David Wheeler <dwheeler@dgitsystems.com>)
Ответы Re: Slow planning, fast execution for particular 3-table query  (David Wheeler <dwheeler@dgitsystems.com>)
Список pgsql-performance
Дерево обсуждения
Is default_statistics_target set above default 100? I would assume that would reflect in the size of pg_statistic, but wanted to ask since increasing that from 100 to 1000 was the only time I have seen planning time explode. Are other queries slow to plan?

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

Предыдущее
От: David Wheeler
Дата:
Сообщение: Re: Slow planning, fast execution for particular 3-table query
Следующее
От: Justin Pryzby
Дата:
Сообщение: Re: Slow planning, fast execution for particular 3-table query