Re: Postgres Parameters

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: Postgres Parameters
Дата
Msg-id ab2f49d04aa30f8382000d309b0eae491d9e8e64.camel@cybertec.at
обсуждение исходный текст
Ответ на Postgres Parameters  (Sam Stearns <sam.stearns@dat.com>)
Список pgsql-admin
On Mon, 2025-11-10 at 15:28 -0800, Sam Stearns wrote:
> Could someone advise on how to determine the correct settings for the following, please?:
>
>  * checkpoint_timeout
>  * max_wal_size

Leave "checkpoint_timeout" as it is, and increase "max_wal_size" to 10GB.
Wait, and if pg_stat_checkpointer tells you that many checkpoints are *not*
triggered by timeout, increase "max_wal_size".

Yours,
Laurenz Albe



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