Re: Linux Filesystems again - Ubuntu this time

From: Whit Armstrong <armstrong(dot)whit(at)gmail(dot)com>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Linux Filesystems again - Ubuntu this time
Date: 2010-07-27 18:20:20
Message-ID: AANLkTi=5KDvSNAjXNOB378oFP-EYtfzMbd=vNoRY6Fsa@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Thanks.

But there is no such risk to turning off write barriers?

I'm only specifying noatime for xfs at the moment.

Did you get a substantial performace boost from disabling write
barriers? like 10x or more like 2x?

Thanks,
Whit

On Tue, Jul 27, 2010 at 1:19 PM, Kevin Grittner
<Kevin(dot)Grittner(at)wicourts(dot)gov> wrote:
> "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> wrote:
>
>> Basically, you should never use fsync unless you are OK with
>> losing everything in the database server if you have an OS or
>> hardware failure.
>
> s/use/disable/
>
> -Kevin
>

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2010-07-27 18:25:25 Re: potential performance gain by query planner optimization
Previous Message Robert Haas 2010-07-27 18:11:27 Re: What is the best way to optimize the query.