From: Kevin Grittner <kgrittn@mail.com>
To: Baptiste LHOSTE <blhoste@alaloop.com>
To: pgsql-admin@postgresql.org
Cc: cedric@2ndquadrant.com
Subject: Re: Autoanalyze of the autovacuum daemon ...
Date: Fri, 09 Nov 2012 09:31:39 -0500
Message-ID: <20121109143139.77870@gmx.com> (raw)
Baptiste LHOSTE wrote:
> Today I consulted the log of my PostgreSQL server and I saw that
> autovacuum tasks took to much time to do their work. I thought that
> ANALYZE was a fast operation ?
That depends on configuration settings and on whether the computer
(or VM) is so swamped that the autovacuum task is starved for cycles.
Also on any overrides of statistics targets for those tables.
Please show us the output from running this query:
http://wiki.postgresql.org/wiki/Server_Configuration
Have you overridden any statistics targets?
A description of the environment would also be good. Hardware? Load?
-Kevin
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: kgrittn@mail.com, blhoste@alaloop.com, cedric@2ndquadrant.com
Subject: Re: Autoanalyze of the autovacuum daemon ...
In-Reply-To: <20121109143139.77870@gmx.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