pgsql: Clamp autovacuum launcher sleep time to 5 minutes

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Clamp autovacuum launcher sleep time to 5 minutes
Date: 2015-06-19 15:59:46
Message-ID: E1Z5yhm-0004C3-7E@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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_4_STABLE

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

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

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2015-06-19 18:24:12 pgsql: In immediate shutdown, postmaster should not exit till children
Previous Message Tom Lane 2015-06-19 15:42:17 pgsql: Fix bogus range_table_mutator() logic for RangeTblEntry.tablesam