| From: | Michael Paquier <michael(at)paquier(dot)xyz> |
|---|---|
| To: | Cliff Clark <Cliff_Clark(at)selinc(dot)com> |
| Cc: | "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: [PATCH] Auto vacuum should still run when clock is set back |
| Date: | 2026-03-25 01:55:58 |
| Message-ID: | acNArg66R8K9EJuU@paquier.xyz |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2026-03-25 01:58:23 | Re: Minor refactor of the code in ExecScanExtended() |
| Previous Message | Chao Li | 2026-03-25 01:55:29 | Re: VACUUM FULL, CLUSTER, and REPACK block on other sessions' temp tables |