From: Andres Freund <andres@anarazel.de>
To: pgsql-performance@postgresql.org
Cc: Richard Shaw <richard@aggress.net>
Cc: Andy Colson <andy@squeakycode.net>
Subject: Re: Rather large LA
Date: Mon, 05 Sep 2011 19:24:17 +0200
Message-ID: <1894838.pasMZSmQAq@alap2> (raw)
In-Reply-To: <97BCA6CA-A1DB-43C7-B710-C2836B656FD6@aggress.net>
References: <F757E48F-2B4F-496D-951B-B04ED98F8FD6@aggress.net>
<4E64D0FE.6020704@squeakycode.net>
<97BCA6CA-A1DB-43C7-B710-C2836B656FD6@aggress.net>
On Monday, September 05, 2011 14:57:43 Richard Shaw wrote:
> Autovacuum has been disabled and set to run manually via cron during a quiet
> period and fsync has recently been turned off to gauge any real world
> performance increase, there is battery backup on the raid card providing
> some level of resilience.
That doesn't help you against a failure due to fsync() off as the BBU can only
protect data that actually has been written to disk. Without fsync=on no
guarantee about that exists.
Andres
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-performance@postgresql.org
Cc: andres@anarazel.de, richard@aggress.net, andy@squeakycode.net
Subject: Re: Rather large LA
In-Reply-To: <1894838.pasMZSmQAq@alap2>
* 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