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 10:59:57 -0500
Message-ID: <20121109155957.77890@gmx.com> (raw)
Baptiste LHOSTE wrote:
>> Please show us the output from running this query:
>>
>> http://wiki.postgresql.org/wiki/Server_Configuration> [very reasonable settings except for a very large work_mem]
Make sure that work_mem setting isn't driving you into swapping or
near-zero caching. A shortage of cache space could explain this
because it looks like about 8.5 ms for each page read. About the only
other thing I can think to recommend is to decrease
autovacuum_cost_delay to 10ms and see if that helps.
> These tables have two timestamp columns and a btree index on both
> timestamp column. Will it be more efficient for us to configure the
> autovacuum daemon analyze task only on those columns ?
No.
> 4 * 300 Go Raid 0
You do realize that if any of those four drives fail you will need to
use your backup, right?
-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: <20121109155957.77890@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