Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <kgrittn@mail.com>) id 1TWpdU-000106-9U
	for pgsql-admin@postgresql.org; Fri, 09 Nov 2012 14:32:44 +0000
Received: from mailout-us.gmx.com ([74.208.5.67])
	by magus.postgresql.org with smtp (Exim 4.72)
	(envelope-from <kgrittn@mail.com>) id 1TWpdS-0004sT-AG
	for pgsql-admin@postgresql.org; Fri, 09 Nov 2012 14:32:43 +0000
Received: (qmail 19306 invoked by uid 0); 9 Nov 2012 14:31:40 -0000
Received: from 76.255.19.161 by rms-us015 with HTTP
Cc: cedric@2ndquadrant.com
Content-Type: text/plain; charset="utf-8"
Date: Fri, 09 Nov 2012 09:31:39 -0500
From: "Kevin Grittner" <kgrittn@mail.com>
Message-ID: <20121109143139.77870@gmx.com>
MIME-Version: 1.0
Subject: Re: Autoanalyze of the autovacuum daemon ...
To: "Baptiste LHOSTE" <blhoste@alaloop.com>,pgsql-admin@postgresql.org
X-Authenticated: #138763884
X-Flags: 0001
X-Mailer: GMX.com Web Mailer
x-registered: 0
Content-Transfer-Encoding: 8bit
X-GMX-UID: nHbvcA9/3zOlOQ09LnwhvPR+IGRvbwBQ
X-Pg-Spam-Score: -1.9 (-)
X-Archive-Number: 201211/58
X-Sequence-Number: 40303

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