Re: [GENERAL] 8.2.3 AutoVacuum not running

2007-04-27 Thread Alvaro Herrera
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

Re: [GENERAL] 8.2.3 AutoVacuum not running

2007-04-11 Thread marcelo Cortez
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 > > in

Re: [GENERAL] 8.2.3 AutoVacuum not running

2007-04-11 Thread Schwenker, Stephen
It says it's on and I have also turned on all stats collecting. -Original Message- From: Alvaro Herrera [mailto:[EMAIL PROTECTED] 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 ru

Re: [GENERAL] 8.2.3 AutoVacuum not running

2007-04-11 Thread Tom Lane
"Schwenker, Stephen" <[EMAIL PROTECTED]> 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 ev

Re: [GENERAL] 8.2.3 AutoVacuum not running

2007-04-09 Thread Matthew T. O'Connor
uggestions? :) *From:* Tom Lane [mailto:[EMAIL PROTECTED] *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" <[E

Re: [GENERAL] 8.2.3 AutoVacuum not running

2007-04-09 Thread Alvaro Herrera
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 wh

Re: [GENERAL] 8.2.3 AutoVacuum not running

2007-04-09 Thread Schwenker, Stephen
t. Thank you, Steve. From: Tom Lane [mailto:[EMAIL PROTECTED] 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" <[EMAIL PROTECTED]> writes: > I've just

Re: [GENERAL] 8.2.3 AutoVacuum not running

2007-04-09 Thread Schwenker, Stephen
ql-general@postgresql.org Subject: Re: [GENERAL] 8.2.3 AutoVacuum not running "Schwenker, Stephen" <[EMAIL PROTECTED]> 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

Re: [GENERAL] 8.2.3 AutoVacuum not running

2007-04-09 Thread Schwenker, Stephen
autovacuum is not working? :) From: Tom Lane [mailto:[EMAIL PROTECTED] 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" <[EMAIL PROTE

Re: [GENERAL] 8.2.3 AutoVacuum not running

2007-04-06 Thread Tom Lane
"Schwenker, Stephen" <[EMAIL PROTECTED]> 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_autovac

[GENERAL] 8.2.3 AutoVacuum not running

2007-04-06 Thread Schwenker, Stephen
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. Can a