| From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | Andres Freund <andres(at)anarazel(dot)de> |
| Cc: | pgsql-performance(at)postgresql(dot)org, Richard Shaw <richard(at)aggress(dot)net>, Andy Colson <andy(at)squeakycode(dot)net> |
| Subject: | Re: Rather large LA |
| Date: | 2011-09-05 20:23:32 |
| Message-ID: | CAOR=d=2WjEiFhbAL4f7EZi38ZeDSexdnhD_EEcgsPd8A8fwc7w@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Mon, Sep 5, 2011 at 11:24 AM, Andres Freund <andres(at)anarazel(dot)de> wrote:
> 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.
Further, if you've got a bbu cache on the RAID card the gains from
fsync=off wll be low / nonexistent.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tomas Vondra | 2011-09-05 20:38:56 | Re: Sudden drop in DBb performance |
| Previous Message | Alan Hodgson | 2011-09-05 20:05:06 | Re: Rather large LA |