Clamp autovacuum launcher sleep time to 5 minutes
authorAlvaro Herrera <alvherre@alvh.no-ip.org>
Fri, 19 Jun 2015 15:44:34 +0000 (12:44 -0300)
committerAlvaro Herrera <alvherre@alvh.no-ip.org>
Fri, 19 Jun 2015 15:44:34 +0000 (12:44 -0300)
commit5ac77a276311a7373950020973967d8d62e20d38
tree2d11f84b7833c8b985cfada63872f91e818b9a84
parent6199b1f90c5c3b800fa4d647e333c194ae4ee933
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