Re: 8.2.3 AutoVacuum not running

Hey, I've just found something else. When I compiled postgresql, I assumed that because it compiled then it was a supported system. This was on the first line of the configure output.

checking build system type... x86_64-unknown-linux-gnu

I've looked at the supported systems list and the x86_64 doesn't appear to be supported. Can someone help me figure out how to make that system type to get supported? Maybe I can turn on some debugging to figure out why it's not running. I'm willing to put in some time to figure it out.

Thank you,


Steve.

________________________________

From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Fri 06/04/2007 1:21 PM
To: Schwenker, Stephen
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] 8.2.3 AutoVacuum not running

"Schwenker, Stephen" <SSchwenker(at)thestar(dot)ca> writes:
> I've just compiled an instance of Postgresql 8.2.3 on a new linux box
> and have added some databases to it. I've noticed however that the
> autovacuum is not running.

How sure are you of that? Check pg_stat_all_tables to see if the
last_autovacuum column is changing.

regards, tom lane