pgsql: Clamp autovacuum launcher sleep time to 5 minutes - Mailing list pgsql-committers

From Alvaro Herrera
Subject pgsql: Clamp autovacuum launcher sleep time to 5 minutes
Date
Msg-id E1Z5yhm-0004CE-87@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
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.

Branch
------
REL9_0_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/d68df5e40d430d03141b531afaf4e5ef8833ef7e

Modified Files
--------------
src/backend/postmaster/autovacuum.c |   10 ++++++++++
1 file changed, 10 insertions(+)


pgsql-committers by date:

Previous
From: Alvaro Herrera
Date:
Subject: pgsql: Clamp autovacuum launcher sleep time to 5 minutes
Next
From: Alvaro Herrera
Date:
Subject: pgsql: Clamp autovacuum launcher sleep time to 5 minutes