From: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
---|---|
To: | Aleksey Tsalolikhin <atsaloli(dot)tech(at)gmail(dot)com> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: check_postgres reports most of my tables are unanalyzed for 8 weeks; why isn't autovacuum analyzing them? |
Date: | 2010-07-20 20:59:57 |
Message-ID: | AANLkTinI0jKv8GwZuqy6SWDqsT5_QAfE0OJ4uEkeQMAM@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, Jul 20, 2010 at 4:31 PM, Aleksey Tsalolikhin
<atsaloli(dot)tech(at)gmail(dot)com> wrote:
> Hi. I've just discovered the check_postgres utility and am running
> all the tests against my database.
>
> The "last_analyze" test comes out critical - many tables unanalyzed
> for 8 weeks.
have those tables been modified at all? this is only an issue if the
database's understanding of the table is different from reality AFIAK.
> P.S. I checked the PostgreSQL logs, and in the last week, I just have
> three messages with "vacuum" in them:
> (I am running at default log levels)
>
> 2010-07-20 02:05:05 PDT ERROR: canceling autovacuum task
> 2010-07-20 02:05:05 PDT CONTEXT: automatic vacuum of table
> "mydb.pg_catalog.pg_listener"
>
> 2010-07-20 07:27:14 PDT ERROR: canceling autovacuum task
> 2010-07-20 07:27:14 PDT CONTEXT: automatic vacuum of table
> "mydb._slony_cluster.sl_event"
>
> 2010-07-20 07:27:53 PDT ERROR: canceling autovacuum task
> 2010-07-20 07:27:53 PDT CONTEXT: automatic vacuum of table
> "mydb._slony_cluster.sl_log_2"
this is normal. note that slony abuses the listener notify system,
and autovac punts to avoid messing with user sessions. 9.0 has a much
cleaner async notify mechanism so won't have this issue.
merlin
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Hamann | 2010-07-20 21:59:01 | printing vector column seems to print the rest of the row too |
Previous Message | Aleksey Tsalolikhin | 2010-07-20 20:43:17 | Re: check_postgres reports most of my tables are unanalyzed for 8 weeks; why isn't autovacuum analyzing them? |