Re: Rather large LA

From: Andres Freund <andres(at)anarazel(dot)de>
To: pgsql-performance(at)postgresql(dot)org
Cc: Richard Shaw <richard(at)aggress(dot)net>, Andy Colson <andy(at)squeakycode(dot)net>
Subject: Re: Rather large LA
Date: 2011-09-05 17:24:17
Message-ID: 1894838.pasMZSmQAq@alap2
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2011-09-05 18:45:57 Re: Sudden drop in DBb performance
Previous Message Andy Colson 2011-09-05 16:47:15 Re: Rather large LA