From: | "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net> |
---|---|
To: | "Schwenker, Stephen" <SSchwenker(at)thestar(dot)ca> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: 8.2.3 AutoVacuum not running |
Date: | 2007-04-09 19:24:58 |
Message-ID: | 461A930A.1060909@zeut.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)sss(dot)pgh(dot)pa(dot)us]
> *Sent:* Fri 06/04/2007 1:21 PM
> *To:* Schwenker, Stephen
> *Cc:* pgsql-general(at)postgresql(dot)org
> *Subject:* Re: [GENERAL] 8.2.3 AutoVacuum not running
>
> "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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Merlin Moncure | 2007-04-09 19:26:00 | Re: How to disable duplicate columns |
Previous Message | Alvaro Herrera | 2007-04-09 19:08:43 | Re: plperl "set-valued function" problem |