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