Re: 8.2.3 AutoVacuum not running - Mailing list pgsql-general

From Schwenker, Stephen
Subject Re: 8.2.3 AutoVacuum not running
Date
Msg-id FBEF1EF7B7E5B649AB1C684991223C6E10230A@tmg-mail2.torstar.net
Whole thread Raw
In response to 8.2.3 AutoVacuum not running  ("Schwenker, Stephen" <SSchwenker@thestar.ca>)
List pgsql-general
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@sss.pgh.pa.us]
Sent: Fri 06/04/2007 1:21 PM
To: Schwenker, Stephen
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] 8.2.3 AutoVacuum not running

"Schwenker, Stephen" <SSchwenker@thestar.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

pgsql-general by date:

Previous
From: Alan Hodgson
Date:
Subject: Re: Problem with copying data
Next
From: "filippo"
Date:
Subject: Re: perl DBI: problems searching text strings with ' symbol (es d'ambrose)