Re: [PATCH] Auto vacuum should still run when clock is set back

From: Cliff Clark <Cliff_Clark(at)selinc(dot)com>
To: Michael Paquier <michael(at)paquier(dot)xyz>
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 16:21:52
Message-ID: SA1PR22MB5466016ED1A11AB363E708D0E549A@SA1PR22MB5466.namprd22.prod.outlook.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

The clock changes are not due to DST, but the UTC system time. There was an NTP server on an offline network that went from 2019 to 2006 due to GPS week number rollover. The date being wrong did cause some problems, but nothing fatal, but several machines filled up their disk to the point of failure because autovacuum was no longer running.

I will attempt to attach the patch again.

________________________________________
From: Michael Paquier <michael(at)paquier(dot)xyz>
Sent: Tuesday, March 24, 2026 18:55
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
 
[You don't often get email from michael(at)paquier(dot)xyz(dot) Learn why this is important at https://aka.ms/LearnAboutSenderIdentification ]

[Caution - External]

Attachment Content-Type Size
0001-Autovacuum-should-still-run-when-clock-is-set-back.patch text/x-patch 1.8 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Cliff Clark 2026-03-25 16:24:13 Re: [PATCH] Auto vacuum should still run when clock is set back
Previous Message Andres Freund 2026-03-25 16:13:08 Re: Test timings are increasing too fast for cfbot