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" <[EMAIL PROTECTED]> escribió: > 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 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
