Re: Auto-vacuum is not running in 9.1.12
От | Cédric Villemain |
---|---|
Тема | Re: Auto-vacuum is not running in 9.1.12 |
Дата | |
Msg-id | 558297EC.7000809@2ndQuadrant.com обсуждение исходный текст |
Ответ на | Re: Auto-vacuum is not running in 9.1.12 (Alvaro Herrera <alvherre@2ndquadrant.com>) |
Ответы |
Re: Auto-vacuum is not running in 9.1.12
|
Список | pgsql-hackers |
Le 17/06/2015 23:10, Alvaro Herrera a écrit : > Tom Lane wrote: >> launcher_determine_sleep() does have a minimum sleep time, and it seems >> like we could fairly cheaply guard against this kind of scenario by also >> enforcing a maximum sleep time (of say 5 or 10 minutes). Not quite >> convinced whether it's worth the trouble though. > > Yeah, the case is pretty weird and I'm not really sure that the server > ought to be expected to behave. But if this is actually the only part > of the server that misbehaves because of sudden gigantic time jumps, I > think it's fair to patch it. Here's a proposed patch. Does that still respect an autovacuum_naptime (GUC) greater than 5 minutes ? -- Cédric Villemain +33 (0)6 20 30 22 52 http://2ndQuadrant.fr/ PostgreSQL: Support 24x7 - Développement, Expertise et Formation
В списке pgsql-hackers по дате отправления: