public inbox for [email protected]
help / color / mirror / Atom feedFrom: Cliff Clark <[email protected]>
To: [email protected] <[email protected]>
Subject: [PATCH] Auto vacuum should still run when clock is set back
Date: Tue, 24 Mar 2026 20:38:21 +0000
Message-ID: <SA1PR22MB5466E3DF88E240271E936E62E548A@SA1PR22MB5466.namprd22.prod.outlook.com> (raw)
If the system clock is set back a large amount after PostgreSQL starts up, auto vacuum may stop running for a very long time.
Attached is a small patch to reschedule the auto vacuum workers when the auto vacuum launcher detects that the current time is before the last time it was run.
I tested this with a script that simply updated a bunch of rows in a test table. Without the fix, the database files keep growing, with the fix, the storage used remains stable.
The patch is based on version f227b7b20c36b7348867eec48d539d28cfdf831c on the master branch of the git repo as of this morning.
Thank you,
Cliff Clark
view thread (4+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: [PATCH] Auto vacuum should still run when clock is set back
In-Reply-To: <SA1PR22MB5466E3DF88E240271E936E62E548A@SA1PR22MB5466.namprd22.prod.outlook.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox