Обсуждение: 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
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
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
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: > 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 >
"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
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
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