Re: file system and raid performance

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Andrej Ricnik-Bay" <andrej(dot)groups(at)gmail(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: file system and raid performance
Date: 2008-08-07 22:12:58
Message-ID: dcc563d10808071512j4f586afcld7782bdb85307e4a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thu, Aug 7, 2008 at 3:57 PM, Andrej Ricnik-Bay
<andrej(dot)groups(at)gmail(dot)com> wrote:
> 2008/8/8 Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>:
>> noatime turns off the atime write behaviour. Or did you already know
>> that and I missed some weird post where noatime somehow managed to
>> slow down performance?
>
> Scott, I'm quite aware of what noatime does ... you didn't miss a post, but
> if you look at Mark's graphs on
> http://wiki.postgresql.org/wiki/HP_ProLiant_DL380_G5_Tuning_Guide
> they pretty much all indicate that (unless I completely misinterpret the
> meaning and purpose of the labels), independent of the file-system,
> using noatime slows read/writes down (on average).

Interesting. While a few of the benchmarks looks noticeably slower
with noatime (reiserfs for instance) most seem faster in that listing.

I am just now setting up our big database server for work and noticed
a MUCH lower performance without noatime.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Gregory Stark 2008-08-07 22:38:07 Re: query planner not using the correct index
Previous Message Mark Mielke 2008-08-07 22:08:59 Re: file system and raid performance