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