Re: Can postgres ever delete the recycled future WAL files to free-up disk space if max_wal_size is reduced or wal_recycle is set to off? - Mailing list pgsql-hackers

From Jacob Champion
Subject Re: Can postgres ever delete the recycled future WAL files to free-up disk space if max_wal_size is reduced or wal_recycle is set to off?
Date
Msg-id f3664b22-ef52-3640-4487-40e6f193b288@timescale.com
Whole thread Raw
In response to Re: Can postgres ever delete the recycled future WAL files to free-up disk space if max_wal_size is reduced or wal_recycle is set to off?  (Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>)
List pgsql-hackers
On 5/13/22 05:35, Bharath Rupireddy wrote:
> Hi, I'm thinking out loud - can we add all the recycled WAL files to a
> sorted list (oldest recycled WAL file to new recycled WAL file) and
> then during checkpoint, if the max_wal_size is reduced or wal_recycle
> is set to off, then start deleting the future WAL files from the end
> of the sorted list. Upon restart of the server, if required, the
> sorted list of future WAL files can be rebuilt.

(This is registered in CF, but there doesn't seem to be a patch as part
of this thread, so I don't think there's anything to review. I've closed
it out to avoid further triage, but if I've somehow missed a patch feel
free to resurrect it -- and maybe point the patch out in an annotation
or something.)

Thanks,
--Jacob



pgsql-hackers by date:

Previous
From: David Rowley
Date:
Subject: Re: Skip partition tuple routing with constant partition key
Next
From: Tom Lane
Date:
Subject: Re: Add test of pg_prewarm extenion