Re: should we enable log_checkpoints out of the box?

Поиск
Список
Период
Сортировка
От Peter Geoghegan
Тема Re: should we enable log_checkpoints out of the box?
Дата
Msg-id CAH2-Wz=Nf8RPb4_i_MB1doPSzq5-ufGJPfT5yHdsiU8yCvZcMg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: should we enable log_checkpoints out of the box?  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: should we enable log_checkpoints out of the box?  (Andrew Dunstan <andrew@dunslane.net>)
Re: should we enable log_checkpoints out of the box?  (Jan Wieck <jan@wi3ck.info>)
Список pgsql-hackers
On Tue, Nov 2, 2021 at 8:55 AM Robert Haas <robertmhaas@gmail.com> wrote:
> I think shipping with log_checkpoints=on and
> log_autovacuum_min_duration=10m or so would be one of the best things
> we could possibly do to allow ex-post-facto troubleshooting of
> system-wide performance issues. The idea that users care more about
> the inconvenience of a handful of extra log messages than they do
> about being able to find problems when they have them matches no part
> of my experience. I suspect that many users would be willing to incur
> *way more* useless log messages than those settings would ever
> generate if it meant that they could actually find problems when and
> if they have them.

I fully agree.

-- 
Peter Geoghegan



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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: archive modules
Следующее
От: "Bossart, Nathan"
Дата:
Сообщение: Re: archive modules