]> granicus.if.org Git - postgresql/commit
Clamp autovacuum launcher sleep time to 5 minutes
authorAlvaro Herrera <alvherre@alvh.no-ip.org>
Fri, 19 Jun 2015 15:44:33 +0000 (12:44 -0300)
committerAlvaro Herrera <alvherre@alvh.no-ip.org>
Fri, 19 Jun 2015 15:44:33 +0000 (12:44 -0300)
commitd68df5e40d430d03141b531afaf4e5ef8833ef7e
tree5cf0a67c1345e7433ff7167ecf79e4de7b9b321e
parentd278ff3b26fb226a6b390e5c8a7dd66cbfc5c37e
Clamp autovacuum launcher sleep time to 5 minutes

This avoids the problem that it might go to sleep for an unreasonable
amount of time in unusual conditions like the server clock moving
backwards an unreasonable amount of time.

(Simply moving the server clock forward again doesn't solve the problem
unless you wake up the autovacuum launcher manually, say by sending it
SIGHUP).

Per trouble report from Prakash Itnal in
https://www.postgresql.org/message-id/CAHC5u79-UqbapAABH2t4Rh2eYdyge0Zid-X=Xz-ZWZCBK42S0Q@mail.gmail.com

Analyzed independently by Haribabu Kommi and Tom Lane.
src/backend/postmaster/autovacuum.c