pgsql: Clamp autovacuum launcher sleep time to 5 minutes

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема pgsql: Clamp autovacuum launcher sleep time to 5 minutes
Дата
Msg-id E1Z5yhm-0004CB-7t@gemulon.postgresql.org
обсуждение исходный текст
Список 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_1_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/2fed5731a39643ddbf9e9127a75664dfd4b21877

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


В списке pgsql-committers по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: pgsql: Clamp autovacuum launcher sleep time to 5 minutes
Следующее
От: Alvaro Herrera
Дата:
Сообщение: pgsql: Clamp autovacuum launcher sleep time to 5 minutes