If the system clock is set back a large amount after PostgreSQL starts up, auto 
vacuum may stop running for a very long time.

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.

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.

Thank you,
Cliff Clark

Reply via email to