Re: pg_autovacuum not sleeping

p == pgman(at)candle(dot)pha(dot)pa(dot)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 after the release of
p> 8.0.3:

p> revision 1.27.4.4
p> date: 2005/05/11 17:58:32; author: momjian; state: Exp; lines: +11 -2
p> Fix pg_autovacuum -s flag to handle values > 2000 by using sleep()
p> instead of pg_usleep.

p> Backpatch to 8.0.X.

p> We are thinking of putting out an 8.0.4 in a few days, but until then
p> you can pull from CVS branch REL8_0_STABLE and use that fix in
p> pg_autovacuum.c.

Thanks. That did the trick.

--
Brandon