Re: pg_restore causing ENOSPACE on the WAL partition. Fundamental issue? - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: pg_restore causing ENOSPACE on the WAL partition. Fundamental issue?
Date
Msg-id CAKFQuwb15hSo4Jie4o5NEpH7_6ZTbZyBYKG1eV7QnNExwDgvxQ@mail.gmail.com
Whole thread Raw
In response to pg_restore causing ENOSPACE on the WAL partition. Fundamental issue?  (Dimitrios Apostolou <jimis@gmx.net>)
List pgsql-hackers
On Thursday, June 12, 2025, Dimitrios Apostolou <jimis@gmx.net> wrote:

Why can't walwriter just refuse to write anything above a certain limit, thus freezing all other writers until the checkpointer frees a chunk of WAL?

There may be performance reasons discouraging this, but more likely it’s just a lack of awareness, or maybe an insufficient benefit/cost ratio to volunteer to address this corner-case scenario.

David J.

pgsql-hackers by date:

Previous
From: Dimitrios Apostolou
Date:
Subject: Re: [PATCH v2] parallel pg_restore: move offset-building phase to before forking
Next
From: Nathan Bossart
Date:
Subject: Re: Replace some %llu remnants in the tree