Quick Links

Re: 8.2.3 AutoVacuum not running

From:	Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:	"Schwenker, Stephen" <SSchwenker(at)thestar(dot)ca>
Cc:	pgsql-general(at)postgresql(dot)org
Subject:	Re: 8.2.3 AutoVacuum not running
Date:	2007-04-06 17:21:48
Message-ID:	14824.1175880108@sss.pgh.pa.us
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

"Schwenker, Stephen" <SSchwenker(at)thestar(dot)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

In response to

8.2.3 AutoVacuum not running at 2007-04-05 18:06:18 from Schwenker, Stephen

Responses

Re: 8.2.3 AutoVacuum not running at 2007-04-07 01:36:07 from Schwenker, Stephen
Re: 8.2.3 AutoVacuum not running at 2007-04-07 02:31:04 from Schwenker, Stephen
Re: 8.2.3 AutoVacuum not running at 2007-04-07 22:15:31 from Schwenker, Stephen

Browse pgsql-general by date

	From	Date	Subject
Next Message	Michael Fuhr	2007-04-06 17:37:30	Re: YTA Time Zone Question
Previous Message	Tom Lane	2007-04-06 17:15:35	Re: YTA Time Zone Question