From: Baptiste LHOSTE <blhoste@alaloop.com>
To: pgsql-admin@postgresql.org
Cc: Sylvain CAILLET <scaillet@alaloop.com>
Cc: cedric@2ndquadrant.com
Subject: Re: Autoanalyze of the autovacuum daemon ...
Date: Thu, 8 Nov 2012 09:54:19 +0100 (CET)
Message-ID: <1564515179.9216202.1352364859841.JavaMail.root@alaloop.com> (raw)
In-Reply-To: <201211051612.45865.cedric@2ndquadrant.com>
Hi,
> So that an auto-ANALYZE should run each 2.5-3 hours.
>
> If it does not proceed, check that you do not have some process still doing manual maintenance or DDL on those tables, they might
> lock the table and kill autovacuum
>
> (check the pg_stat_activity, and set log_autovacuum_min_duration=0 to track all job done by autovacuum)
Sorry for my late answer, but since two days I noticed some improvements so I decided to wait a little bit to confirm these.
Finally the autovacuum daemon seems to work correctly. It does not proceed an auto-ANALYZE each 3 hours, it is more about each 12 hours but it is much better than at the beginning.
The fact is the autovacuum daemon took about 10 days to become effective on both kind of tables, maybe it needs this period to catch up and be effective.
Thanks for your time, Regards, Baptiste.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: blhoste@alaloop.com, scaillet@alaloop.com, cedric@2ndquadrant.com
Subject: Re: Autoanalyze of the autovacuum daemon ...
In-Reply-To: <1564515179.9216202.1352364859841.JavaMail.root@alaloop.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox