Re: Linux Filesystems again - Ubuntu this time - Mailing list pgsql-performance

From Whit Armstrong
Subject Re: Linux Filesystems again - Ubuntu this time
Date
Msg-id AANLkTi=5KDvSNAjXNOB378oFP-EYtfzMbd=vNoRY6Fsa@mail.gmail.com
Whole thread Raw
In response to Re: Linux Filesystems again - Ubuntu this time  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: Linux Filesystems again - Ubuntu this time  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List 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.Grittner@wicourts.gov> wrote:
> "Kevin Grittner" <Kevin.Grittner@wicourts.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
>

pgsql-performance by date:

Previous
From: Robert Haas
Date:
Subject: Re: What is the best way to optimize the query.
Next
From: Tom Lane
Date:
Subject: Re: potential performance gain by query planner optimization