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 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