Re: Rather large LA - Mailing list pgsql-performance

From Andres Freund
Subject Re: Rather large LA
Date
Msg-id 1894838.pasMZSmQAq@alap2
Whole thread Raw
In response to Re: Rather large LA  (Richard Shaw <richard@aggress.net>)
Responses Re: Rather large LA
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Andy Colson
Date:
Subject: Re: Rather large LA
Next
From: Scott Marlowe
Date:
Subject: Re: Sudden drop in DBb performance