Re: [PATCH] Auto vacuum should still run when clock is set back - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: [PATCH] Auto vacuum should still run when clock is set back
Date
Msg-id acNArg66R8K9EJuU@paquier.xyz
Whole thread Raw
In response to [PATCH] Auto vacuum should still run when clock is set back  (Cliff Clark <Cliff_Clark@selinc.com>)
List pgsql-hackers
On Tue, Mar 24, 2026 at 08:38:21PM +0000, Cliff Clark wrote:
> 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.

Do you mean clock changes, particularly due to Winter/Summer time
switches?

> 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.

You have not posted a patch, as far as I can see, so it is not really
possible to comment about your intention.
--
Michael

Attachment

pgsql-hackers by date:

Previous
From: Chao Li
Date:
Subject: Re: VACUUM FULL, CLUSTER, and REPACK block on other sessions' temp tables
Next
From: Michael Paquier
Date:
Subject: Re: Minor refactor of the code in ExecScanExtended()