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

I'm sure. That column is null for all tables in my databases accept for the few tables that I've vacuumed manually.

Any other suggestions? :)

________________________________

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

Hey,

I've also notice one difference between my 8.1 instance and my 8.2 instance. I run a ps and on the 8.1 instance there is a 'stats buffer process' and in the 8.2 instance there is no 'stats buffer instance'

Does that give you anymore reasons as to why the autovacuum is not working?

:)

________________________________

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

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

Schwenker, Stephen wrote:

Hey,

I've also notice one difference between my 8.1 instance and my 8.2
instance. I run a ps and on the 8.1 instance there is a 'stats buffer
process' and in the 8.2 instance there is no 'stats buffer instance'

Does that give you anymore reasons as to why the autovacuum is not working?

No -- the stats buffer process was removed in 8.2 on purpose.

If you do a "show autovacuum", does it show as on? Maybe it was
disabled due to misconfiguration.

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

OK, do you have the stats system enabled also? You require at least
row_level stats for autovacuum to work.

Schwenker, Stephen wrote:

It says it's on and I have also turned on all stats collecting.

-----Original Message-----
From: Alvaro Herrera [mailto:alvherre@commandprompt.com]
Sent: Monday, April 09, 2007 3:06 PM
To: Schwenker, Stephen
Cc: Tom Lane; pgsql-general@postgresql.org
Subject: Re: [GENERAL] 8.2.3 AutoVacuum not running

Schwenker, Stephen wrote:

Hey,

I've also notice one difference between my 8.1 instance and my 8.2
instance. I run a ps and on the 8.1 instance there is a 'stats buffer

process' and in the 8.2 instance there is no 'stats buffer instance'

Does that give you anymore reasons as to why the autovacuum is not

working?

No -- the stats buffer process was removed in 8.2 on purpose.

If you do a "show autovacuum", does it show as on? Maybe it was
disabled due to misconfiguration.

--
Alvaro Herrera
http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

"Schwenker, Stephen" <SSchwenker@thestar.ca> writes:

It says it's on and I have also turned on all stats collecting.

My guess is that it's actually running but is not choosing to do any
vacuums for some reason. Try setting log_min_messages to DEBUG5 for
awhile and trawling the postmaster log for evidence. You should at
minimum see messages indicating that the postmaster is launching an
autovac worker process once a minute; the next question is what that
process is doing with itself. (You might want to adjust log_line_prefix
to include PID so that you can track which messages come from which
process. I find including a timestamp is often helpful also.)

regards, tom lane

Hi folks

I Agree with Stephen ,before update to 8.2.3 version
i can see "vacuum database xxxxxx "
tailing the file log, off course log statements i'ts
in 'all' .
After update don't see anymore, plus pgAdmin reclaim
to me for vacuum databases.
best regards
MDC

--- "Schwenker, Stephen" <SSchwenker@thestar.ca>
escribi�:

It says it's on and I have also turned on all stats
collecting.

-----Original Message-----
From: Alvaro Herrera
[mailto:alvherre@commandprompt.com]
Sent: Monday, April 09, 2007 3:06 PM
To: Schwenker, Stephen
Cc: Tom Lane; pgsql-general@postgresql.org
Subject: Re: [GENERAL] 8.2.3 AutoVacuum not running

Schwenker, Stephen wrote:

Hey,

I've also notice one difference between my 8.1

instance and my 8.2

instance. I run a ps and on the 8.1 instance

there is a 'stats buffer

process' and in the 8.2 instance there is no

'stats buffer instance'

Does that give you anymore reasons as to why the

autovacuum is not
working?

No -- the stats buffer process was removed in 8.2 on
purpose.

If you do a "show autovacuum", does it show as on?
Maybe it was
disabled due to misconfiguration.

--
Alvaro Herrera
http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom
Development, 24x7 support

---------------------------(end of
broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

__________________________________________________
Pregunt�. Respond�. Descubr�.
Todo lo que quer�as saber, y lo que ni imaginabas,
est� en Yahoo! Respuestas (Beta).
�Probalo ya!
http://www.yahoo.com.ar/respuestas

Schwenker, Stephen wrote:

Hello,

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. I have turned on the autovacuum,
stats_start_collector, and stats_row_level and still the autovacuum is
not running.

Was this solved?

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support