From: Cliff Clark <Cliff_Clark@selinc.com>
To: Michael Paquier <michael@paquier.xyz>
CC: "pgsql-hackers@lists.postgresql.org" <pgsql-hackers@lists.postgresql.org>
Subject: Re: [PATCH] Auto vacuum should still run when clock is set back
Thread-Topic: [PATCH] Auto vacuum should still run when clock is set back
Thread-Index: AQHcu8tm8W+1dSJvG0OmrYFfWlT1HbW+fXUAgADw4Mc=
Date: Wed, 25 Mar 2026 16:21:52 +0000
Message-ID: 
 <SA1PR22MB5466016ED1A11AB363E708D0E549A@SA1PR22MB5466.namprd22.prod.outlook.com>
References: 
 <SA1PR22MB5466E3DF88E240271E936E62E548A@SA1PR22MB5466.namprd22.prod.outlook.com>
 <acNArg66R8K9EJuU@paquier.xyz>
In-Reply-To: <acNArg66R8K9EJuU@paquier.xyz>
Accept-Language: en-US
Content-Language: en-US
msip_labels: 
authentication-results: dkim=none (message not signed)
 header.d=none;dmarc=none action=none header.from=selinc.com;
x-ms-publictraffictype: Email
x-ms-traffictypediagnostic: SA1PR22MB5466:EE_|SJ2PR22MB4166:EE_
x-ms-office365-filtering-correlation-id: 0cfdfcef-9119-48e6-7de9-08de8a8a9ffe
x-ms-exchange-senderadcheck: 1
x-ms-exchange-antispam-relay: 0
x-microsoft-antispam: 
 BCL:0;ARA:13230040|366016|1800799024|376014|6049299003|4013099003|4053099003|56012099003|18002099003|7053199007|22082099003|38070700021;
x-microsoft-antispam-message-info: 
 H/cW9HO0Cub5OyI8zfRKEuErwmXSHYDKS/FMEXZG/yXiHt9hanEXAFNH6i4bg8w/iOl3tZVn/4dLvTZ+BYYtsjJlArxzKBGd+R3GfkLh4ayEiFn7sn3UHwcoRB9O8aXp/Xrv2bsmisr/DiKNgEfL2IFKwUmA5j1UwB9rvvDOFgdU4yYWjrENM27ZTlLnR9ie8tEXJdZyJtJZ7TcE49uV18+FPXgUE1k7CbhhkAMSzE0DCDVbnrSH5vL8Jh12SxU7awlDfxyYXIABLogm8iWs5Qtmb+fyZrHfdyKhEyjapRquhnc9PnVopiG32R48dSw+Ahi9qi5cM91tNT7TEJo8PJk1KTtZfx0LzEwgbbd/MdQzrMbeCZSrBjJU7v56edifXafSq9/32RofPZuVCvKKJmCdGFB19cgwUFWonC7WS0774iwnY9xDbHFfMn54czNv/2iVGIeBP1048Z8qc8eKOgjsIqqVrLHLdCc9GstBQGeyzc4xE0Gg6caG1nWNOLkUPutWZTWuGBgYj7TqCyd+va0lAQlK0TYtFs6QZdbnapJMKGPOuLwoiSt0N2Y+7qHjxtIn13SoXGPDohhjQZfxTDobGu19yOftVW1pUq+aPtH8fRb2dW3ucyGVcvtXHOQmOjrKL/yQo0bY9lC6Kkk4ej9lUaO1icVSKG+gpWjklXEGfgVIOFJDHI04Jeen+L+HtZnQDJB3Tnl3giRwiC5V4dJllkEq2P2alecY0KMTbQD4cXMLU1mngUjm0ewWZuYeelLOk1dAOt4A6PzmITOqVuitMLnuLygJyUrEWFfeByY=
x-forefront-antispam-report: 
 CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:SA1PR22MB5466.namprd22.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230040)(366016)(1800799024)(376014)(6049299003)(4013099003)(4053099003)(56012099003)(18002099003)(7053199007)(22082099003)(38070700021);DIR:OUT;SFP:1101;
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0: 
 =?iso-8859-1?Q?XFOqB4RkpOr04ruYvdLqt3ylu47U++oexh9v/I3wctZiEzaSQmfjqVS8On?=
 =?iso-8859-1?Q?R4Lh8OtV4bcHdfyxRz6Rseeww9D1/kOsdNlC6dp1AblNUE1gPGKQvY/LMl?=
 =?iso-8859-1?Q?zb5s/V7sDa0IVYpK7martJaBB8eZcta4XUUNaTuGYtQG5MYk6KCAvNhjkK?=
 =?iso-8859-1?Q?1mVy198BexLVEuMm2JNedTA+qmy5iMpA/p/AguTbHECVU5OIiEik8URM93?=
 =?iso-8859-1?Q?cWpqIWAZx8IMMZUJziCvFNJJuidQkSQ5vMxCLq8Q7NBcth6h7SGw1WJ2j1?=
 =?iso-8859-1?Q?D80wV8d6uLQHuOu3K9XnsGft+0DI8fztpITuxUSz2HDd7smeCguvy6PoCV?=
 =?iso-8859-1?Q?SeodU64HvmtxkcVHDeGJ3OLV6l+006BEj0OaNrH5/Ptx8H8DVs3Uf5NRk+?=
 =?iso-8859-1?Q?92UXXCFFgPTzEOc5hY/XSM4fWgFEd8jIf9C787wcV9EfNyoxSkp8ECH6Ui?=
 =?iso-8859-1?Q?xTaJqEXm0t0ZYyGjpj8EIGommQmiF7MmwwXZcMRK40fYLh4jiMtERSIhxa?=
 =?iso-8859-1?Q?a0VpxGBi2FzAnmsYsGj+MZewT2/1gOnPRl0jfa+8fQ2OVogvFg1ecKg8Jm?=
 =?iso-8859-1?Q?+aYte4PulDu3p6fTiMiW99xr8Bfz6o2/JfYOhxvclAobfrDO27R3odstAJ?=
 =?iso-8859-1?Q?wMZOrqd892quF/jIGC802VVqtY42zVl2Ji1191rWaHerX6Mh6PSo5ccEIG?=
 =?iso-8859-1?Q?KpLYQpE0IHo5u00VOGpRKywsVOYQR3o7AxInzQDn7s0+b0ani0VpWKmIFW?=
 =?iso-8859-1?Q?Cv/XPp956KFH0Y2zv1ixmuyRGINdjThgudS2LBr+SWfZM0aHA0zMX5+DCQ?=
 =?iso-8859-1?Q?6CQgEeOLonUdD0zXmAI5jXKbrUli+P+q+eT2hSIdEGfvfagsS373jDT2Xf?=
 =?iso-8859-1?Q?+f68yprRMavhCLLzcKlGDismvPLCrIEGBwbce9lPwdAsOXzgMP9wuTwa4V?=
 =?iso-8859-1?Q?nFPxa01aHISYEhYTH2tMTmvYbPoBO1+eczRcgq8w8ylCMheidRdlEHaVZz?=
 =?iso-8859-1?Q?sxTnc8oAId70Qv5aXT1Ogzs6YuLtBOn6F/3jEx4+s0LsKO1Los/YPTeVCV?=
 =?iso-8859-1?Q?gTr0Rat5B5Q0mo4Nch+Xj5WZ0NpiR+1ZdULlZDHMZwgM7gUSp+qNy5gk01?=
 =?iso-8859-1?Q?nQwEaMh8ItU4X1hSvAqU1CPFnEaMhfOcEAeIT0Bbm4XkZequg9mR5G6z8k?=
 =?iso-8859-1?Q?GcyzVYrOKWrZAeo2O8F8IRIKIgYif4/UOk+FXFDzUeE+G9Cc5yA+UtKbm0?=
 =?iso-8859-1?Q?o/yDBMdAENMLXXEXPXZcOYIR0J4KHT7OvPIbzg3k27KPjd/Ih0b/aMhibe?=
 =?iso-8859-1?Q?BPf+dj9A7oWzwdWFmiK+QjiOK0peRwY9wW68zXHuLoyyDq3Ehk4pTIvwnl?=
 =?iso-8859-1?Q?KNaszNhAK+AcWyF4wbp+sXELm4AbVtOMQfo6bmZGU9/DOX1HZjzMfYjcBN?=
 =?iso-8859-1?Q?CWex/Rvsjmr4KXwnI0loPZx1nZ6f70uvC+j299C8RiV9YcvnKcQnzAE0ha?=
 =?iso-8859-1?Q?Wv6UGU4vBcKKM8p+PFNmSpXiVjhWl8Zr86V2EH6SXB+Y2k+FzgeCUAXQGJ?=
 =?iso-8859-1?Q?gS1nh2PGcMIVVjTlg6xEBjw98vMEFf2YBxfljJ42WP6IxCoIuK1cjdWISF?=
 =?iso-8859-1?Q?ifmJ3Qn0gBtn4701GddpwKMgaOcF9aD324FBf0NacLgImyrkb5SA/B97Co?=
 =?iso-8859-1?Q?r3WHIJq0FIBt0tV0nSQAuKpyDQ97b29v+XqO7bVChAh3Bn/wN7h5PfZHQK?=
 =?iso-8859-1?Q?eBZf8XDiYnlz/8T1OxZLDrrxe4gyZpfxR96fu3BOCMaFwkCQEhJ2nouzgQ?=
 =?iso-8859-1?Q?Z04nbg5zrQ=3D=3D?=
Content-Type: multipart/mixed;
	boundary="_002_SA1PR22MB5466016ED1A11AB363E708D0E549ASA1PR22MB5466namp_"
MIME-Version: 1.0
X-OriginatorOrg: selinc.com
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: SA1PR22MB5466.namprd22.prod.outlook.com
X-MS-Exchange-CrossTenant-Network-Message-Id: 
 0cfdfcef-9119-48e6-7de9-08de8a8a9ffe
X-MS-Exchange-CrossTenant-originalarrivaltime: 25 Mar 2026 16:21:52.7487
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 12381f30-10fe-4e2c-aa3a-5e03ebeb59ec
X-MS-Exchange-CrossTenant-mailboxtype: HOSTED
X-MS-Exchange-CrossTenant-userprincipalname: 
 rtqoTcLquiMOPn+ImrOJpkl0D5VP0WBOPbHdHaQdP5+7Ce9BG3sb9TzektbhHDE4W/9D77ecw5tEzdABAbDvuw==
X-MS-Exchange-Transport-CrossTenantHeadersStamped: SJ2PR22MB4166
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Archived-At: 
 <https://www.postgresql.org/message-id/SA1PR22MB5466016ED1A11AB363E708D0E549A%40SA1PR22MB5466.namprd22.prod.outlook.com>
Precedence: bulk

--_002_SA1PR22MB5466016ED1A11AB363E708D0E549ASA1PR22MB5466namp_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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 we=
ek number rollover. The date being wrong did cause some problems, but nothi=
ng fatal, but several machines filled up their disk to the point of failure=
 because autovacuum was no longer running.=0A=
=0A=
I will attempt to attach the patch again.=0A=
=0A=
________________________________________=0A=
From:=A0Michael Paquier <michael@paquier.xyz>=0A=
Sent:=A0Tuesday, March 24, 2026 18:55=0A=
To:=A0Cliff Clark <Cliff_Clark@selinc.com>=0A=
Cc:=A0pgsql-hackers@lists.postgresql.org <pgsql-hackers@lists.postgresql.or=
g>=0A=
Subject:=A0Re: [PATCH] Auto vacuum should still run when clock is set back=
=0A=
=A0=0A=
[You don't often get email from michael@paquier.xyz. Learn why this is impo=
rtant at https://aka.ms/LearnAboutSenderIdentification=A0]=0A=
=0A=
[Caution - External]=

--_002_SA1PR22MB5466016ED1A11AB363E708D0E549ASA1PR22MB5466namp_
Content-Type: text/x-patch;
	name="0001-Autovacuum-should-still-run-when-clock-is-set-back.patch"
Content-Description: 
 0001-Autovacuum-should-still-run-when-clock-is-set-back.patch
Content-Disposition: attachment;
	filename="0001-Autovacuum-should-still-run-when-clock-is-set-back.patch";
	size=1845; creation-date="Wed, 25 Mar 2026 16:20:50 GMT";
	modification-date="Wed, 25 Mar 2026 16:20:50 GMT"
Content-Transfer-Encoding: base64

RnJvbSBhN2YwNGE4YjUyMDJlYjc5NGVkNjg0NmJiOGZkZGNjZGVlY2Q2NDNjIE1vbiBTZXAgMTcg
MDA6MDA6MDAgMjAwMQpGcm9tOiBDbGlmZiBDbGFyayA8Q2xpZmZfQ2xhcmtAc2VsaW5jLmNvbT4K
RGF0ZTogVHVlLCAyNCBNYXIgMjAyNiAxMTozMjo0MyAtMDcwMApTdWJqZWN0OiBbUEFUQ0hdIEF1
dG92YWN1dW0gc2hvdWxkIHN0aWxsIHJ1biB3aGVuIGNsb2NrIGlzIHNldCBiYWNrCgpBZGQgY29k
ZSB0byBkZXRlY3Qgd2hlbiB0aGUgY2xvY2sgd2FzIHNldCBiYWNrIHNpbmNlIHRoZSBsYXN0IGF1
dG92YWN1dW0KbGF1bmNoZXIgcnVuLiBXaGVuIHRoaXMgaGFwcGVucywgcmVidWlsZCB0aGUgZGF0
YWJhc2UgbGlzdCBzbyB0aGF0CmF1dG92YWN1dW0gd2lsbCBjb250aW51ZSB0byBydW4uCi0tLQog
c3JjL2JhY2tlbmQvcG9zdG1hc3Rlci9hdXRvdmFjdXVtLmMgfCAxNyArKysrKysrKysrKysrKysr
KwogMSBmaWxlIGNoYW5nZWQsIDE3IGluc2VydGlvbnMoKykKCmRpZmYgLS1naXQgYS9zcmMvYmFj
a2VuZC9wb3N0bWFzdGVyL2F1dG92YWN1dW0uYyBiL3NyYy9iYWNrZW5kL3Bvc3RtYXN0ZXIvYXV0
b3ZhY3V1bS5jCmluZGV4IDIxOTY3M2RiOTMwLi45ZjJjNjQzNDgwMiAxMDA2NDQKLS0tIGEvc3Jj
L2JhY2tlbmQvcG9zdG1hc3Rlci9hdXRvdmFjdXVtLmMKKysrIGIvc3JjL2JhY2tlbmQvcG9zdG1h
c3Rlci9hdXRvdmFjdXVtLmMKQEAgLTM3Nyw2ICszNzcsNyBAQCB2b2lkCiBBdXRvVmFjTGF1bmNo
ZXJNYWluKGNvbnN0IHZvaWQgKnN0YXJ0dXBfZGF0YSwgc2l6ZV90IHN0YXJ0dXBfZGF0YV9sZW4p
CiB7CiAJc2lnam1wX2J1Zglsb2NhbF9zaWdqbXBfYnVmOworCVRpbWVzdGFtcFR6CWxhc3RfY3Vy
cmVudF90aW1lOwogCiAJQXNzZXJ0KHN0YXJ0dXBfZGF0YV9sZW4gPT0gMCk7CiAKQEAgLTU2OCw2
ICs1NjksMTIgQEAgQXV0b1ZhY0xhdW5jaGVyTWFpbihjb25zdCB2b2lkICpzdGFydHVwX2RhdGEs
IHNpemVfdCBzdGFydHVwX2RhdGFfbGVuKQogCiAJQXV0b1ZhY3V1bVNobWVtLT5hdl9sYXVuY2hl
cnBpZCA9IE15UHJvY1BpZDsKIAorCS8qCisJICogU2V0IHRoZSBpbml0aWFsIGxhc3QgcnVuIHRp
bWUgdG8ganVzdCBiZWZvcmUgd2UgYnVpbGQgdGhlIHdvcmtlcgorCSAqIHNjaGVkdWxlLgorCSAq
LworCWxhc3RfY3VycmVudF90aW1lID0gR2V0Q3VycmVudFRpbWVzdGFtcCgpOworCiAJLyoKIAkg
KiBDcmVhdGUgdGhlIGluaXRpYWwgZGF0YWJhc2UgbGlzdC4gIFRoZSBpbnZhcmlhbnQgd2Ugd2Fu
dCB0aGlzIGxpc3QgdG8KIAkgKiBrZWVwIGlzIHRoYXQgaXQncyBvcmRlcmVkIGJ5IGRlY3JlYXNp
bmcgbmV4dF93b3JrZXIuICBBcyBzb29uIGFzIGFuCkBAIC02NDksNiArNjU2LDE2IEBAIEF1dG9W
YWNMYXVuY2hlck1haW4oY29uc3Qgdm9pZCAqc3RhcnR1cF9kYXRhLCBzaXplX3Qgc3RhcnR1cF9k
YXRhX2xlbikKIAkJICovCiAKIAkJY3VycmVudF90aW1lID0gR2V0Q3VycmVudFRpbWVzdGFtcCgp
OworCQlpZiAoY3VycmVudF90aW1lIDwgbGFzdF9jdXJyZW50X3RpbWUpCisJCXsKKwkJCS8qCisJ
CQkgKiBUaGUgY2xvY2sganVtcGVkIGJhY2t3YXJkcyBzbyByZXNjaGVkdWxlIHRoZSB3b3JrZXJz
IHNvIHRoYXQKKwkJCSAqIGRhdGFiYXNlcyB3b24ndCBzdG9wIGdldHRpbmcgYXV0by12YWN1dW1l
ZC4KKwkJCSAqLworCQkJcmVidWlsZF9kYXRhYmFzZV9saXN0KEludmFsaWRPaWQpOworCQl9CisJ
CWxhc3RfY3VycmVudF90aW1lID0gY3VycmVudF90aW1lOworCiAJCUxXTG9ja0FjcXVpcmUoQXV0
b3ZhY3V1bUxvY2ssIExXX1NIQVJFRCk7CiAKIAkJY2FuX2xhdW5jaCA9IGF2X3dvcmtlcl9hdmFp
bGFibGUoKTsKLS0gCjIuNDMuMAoK

--_002_SA1PR22MB5466016ED1A11AB363E708D0E549ASA1PR22MB5466namp_--