Re: file system and raid performance

From: "Mark Wong" <markwkm(at)gmail(dot)com>
To: "Mark Mielke" <mark(at)mark(dot)mielke(dot)cc>
Cc: "Andrej Ricnik-Bay" <andrej(dot)groups(at)gmail(dot)com>, "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: file system and raid performance
Date: 2008-08-08 16:56:15
Message-ID: 70c01d1d0808080956p6edd172dgb0125a64fad19265@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thu, Aug 7, 2008 at 3:08 PM, Mark Mielke <mark(at)mark(dot)mielke(dot)cc> wrote:
> Andrej Ricnik-Bay 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)
>
> That doesn't make sense - if noatime slows things down, then the analysis is
> probably wrong.
>
> Now, modern Linux distributions default to "relatime" - which will only
> update access time if the access time is currently less than the update time
> or something like this. The effect is that modern Linux distributions do not
> benefit from "noatime" as much as they have in the past. In this case,
> "noatime" vs default would probably be measuring % noise.

Interesting, now how would we see if it is defaulting to "relatime"?

Regards,
Mark

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Henrik 2008-08-08 19:21:54 Re: Filesystem benchmarking for pg 8.3.3 server
Previous Message Mark Wong 2008-08-08 16:44:33 Re: Filesystem benchmarking for pg 8.3.3 server