Re: [GENERAL] pg_autovacuum not sleeping

2005-09-21 Thread Brandon Metcalf
p == pgman@candle.pha.pa.us writes: p> Brandon Metcalf wrote: ... p> > So, pg_autovacuum says it's going to sleep for 4886 seconds, but fires p> > up again after just under 600 seconds. p> > p> > Can anyone explain what I'm seeing? p> Yep, this was fixed in 8.0.X CVS in May, two days aft

Re: [GENERAL] pg_autovacuum not sleeping

2005-09-20 Thread Bruce Momjian
Brandon Metcalf wrote: > We're using pg_autovacuum with PostgreSQL 8.0.3 and it isn't sleeping > as long as the claims it will. For example, > > ... > [2005-09-20 15:40:23 CDT] INFO: last_analyze_count: 21735550; > last_vacuum_count: 21735009 > [2005-09-20 15:40:23 CDT] INFO:

[GENERAL] pg_autovacuum not sleeping

2005-09-20 Thread Brandon Metcalf
We're using pg_autovacuum with PostgreSQL 8.0.3 and it isn't sleeping as long as the claims it will. For example, ... [2005-09-20 15:40:23 CDT] INFO: last_analyze_count: 21735550; last_vacuum_count: 21735009 [2005-09-20 15:40:23 CDT] INFO: analyze_threshold: 40676; vacuum_