Re: Searching for the cause of a bad plan

Поиск
Список
Период
Сортировка
От Ron Mayer
Тема Re: Searching for the cause of a bad plan
Дата
Msg-id 46FBF174.1020206@cheapcomplexdevices.com
обсуждение исходный текст
Ответ на Re: Searching for the cause of a bad plan  (Csaba Nagy <nagy@ecircle-ag.com>)
Ответы Re: Searching for the cause of a bad plan  (Csaba Nagy <nagy@ecircle-ag.com>)
Список pgsql-performance
Csaba Nagy wrote:
>
> Well, my problem was actually solved by rising the statistics target,

Would it do more benefit than harm if postgres increased the
default_statistics_target?

I see a fair number of people (myself included) asking questions who's
resolution was to ALTER TABLE SET STATISTICS; and I think relatively
fewer (if any?) people concerned about space in pg_statistic
or people improving analyze time by reducing the statistics target.

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

Предыдущее
От: Kevin Kempter
Дата:
Сообщение: Tuning for warm standby
Следующее
От: "Peter Koczan"
Дата:
Сообщение: sequence query performance issues