Re: check_postgres reports most of my tables are unanalyzed for 8 weeks; why isn't autovacuum analyzing them?

From: Aleksey Tsalolikhin <atsaloli(dot)tech(at)gmail(dot)com>
To: 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:43:17
Message-ID: AANLkTik3ewpTTx5XkB6o4PC5zaUKrsMtFix-FvFrjkqi@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am sorry for the multiple posts; just noticed there are two tests
for analyze: last_analyze and last_autoanalyze

last_autoanalyze matches last_autovacuum - 7 weeks ago

Aleksey

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2010-07-20 20:59:57 Re: check_postgres reports most of my tables are unanalyzed for 8 weeks; why isn't autovacuum analyzing them?
Previous Message Aleksey Tsalolikhin 2010-07-20 20:41:16 Re: check_postgres reports most of my tables are unanalyzed for 8 weeks; why isn't autovacuum analyzing them?