Re: pg_restore causing ENOSPACE on the WAL partition

Поиск
Список
Период
Сортировка
От Dimitrios Apostolou
Тема Re: pg_restore causing ENOSPACE on the WAL partition
Дата
Msg-id 34bc1ed2-4b06-2172-e4f0-2c85bf6208c5@gmx.net
обсуждение исходный текст
Ответ на pg_restore causing ENOSPACE on the WAL partition  (Dimitrios Apostolou <jimis@gmx.net>)
Список pgsql-general
Forgot an important setting I have during pg_restore:

On Thu, 10 Apr 2025, Dimitrios Apostolou wrote:

> max_wal_size=64GB
> max_replication_slots = 0
> max_logical_replication_workers = 0
> max_wal_senders = 0
> wal_level = minimal
> autovacuum = off

checkpoint_completion_target = 0

so the checkpoint should finish ASAP and any delays are purely because of
I/O limitations. And for the sake of completion:

checkpoint_timeout = 600s


Regards,
Dimitris



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