Re: file system and raid performance - Mailing list pgsql-performance

From Mark Mielke
Subject Re: file system and raid performance
Date
Msg-id 489B727B.6010800@mark.mielke.cc
Whole thread Raw
In response to Re: file system and raid performance  ("Andrej Ricnik-Bay" <andrej.groups@gmail.com>)
Responses Re: file system and raid performance
Re: file system and raid performance
Re: file system and raid performance
Re: file system and raid performance
List pgsql-performance
Andrej Ricnik-Bay wrote:
2008/8/8 Scott Marlowe <scott.marlowe@gmail.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.

Cheers,
mark

-- 
Mark Mielke <mark@mielke.cc>

pgsql-performance by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: file system and raid performance
Next
From: Gregory Stark
Date:
Subject: Re: query planner not using the correct index