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