From: | "Schwenker, Stephen" <SSchwenker(at)thestar(dot)ca> |
---|---|
To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: 8.2.3 AutoVacuum not running |
Date: | 2007-04-07 01:36:07 |
Message-ID: | FBEF1EF7B7E5B649AB1C684991223C6E102308@tmg-mail2.torstar.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 | Schwenker, Stephen | 2007-04-07 02:31:04 | Re: 8.2.3 AutoVacuum not running |
Previous Message | tom | 2007-04-07 00:48:22 | Re: SQL WHERE: many sql or large IN() |