Re: Auto-vacuum is not running in 9.1.12 - Mailing list pgsql-hackers

From Cédric Villemain
Subject Re: Auto-vacuum is not running in 9.1.12
Date
Msg-id 558297EC.7000809@2ndQuadrant.com
Whole thread Raw
In response to Re: Auto-vacuum is not running in 9.1.12  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Responses Re: Auto-vacuum is not running in 9.1.12  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List 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 by date:

Previous
From: Michael Paquier
Date:
Subject: Re: The real reason why TAP testing isn't ready for prime time
Next
From: Alvaro Herrera
Date:
Subject: Re: Auto-vacuum is not running in 9.1.12