pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Scott Marlowe <scott.marlowe@gmail.com>
To: Andrej Ricnik-Bay <andrej.groups@gmail.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: file system and raid performance
Date: Thu, 7 Aug 2008 16:12:58 -0600
Message-ID: <dcc563d10808071512j4f586afcld7782bdb85307e4a@mail.gmail.com> (raw)
In-Reply-To: <b35603930808071457x40334261uad77dab2623f2757@mail.gmail.com>
References: <70c01d1d0808042154u7b78d988vac1e461a93b0ba10@mail.gmail.com>
	<4898E80A.3020809@paradise.net.nz>
	<!&!AAAAAAAAAAAYAAAAAAAAAN6d+lQFliBLjc3jO6z0BSQigQAAEAAAACuRbLwxhvtBt2ld+TeOyw4BAAAAAA==@tcscs.com>
	<489A3B75.6060004@paradise.net.nz>
	<489AC2F0.9050907@paradise.net.nz>
	<489ACC90.9030401@sime.com>
	<70c01d1d0808071236u36fe5002w833582b036d952e8@mail.gmail.com>
	<b35603930808071359s6764d230u11fcaaec267ab289@mail.gmail.com>
	<dcc563d10808071430ja002d46x5459e535e97d5419@mail.gmail.com>
	<b35603930808071457x40334261uad77dab2623f2757@mail.gmail.com>

On Thu, Aug 7, 2008 at 3:57 PM, Andrej Ricnik-Bay
<andrej.groups@gmail.com> 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).

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.



view thread (34+ messages)  latest in thread

Message-ID: <dcc563d10808071512j4f586afcld7782bdb85307e4a@mail.gmail.com>
Permalink:  ../dcc563d10808071512j4f586afcld7782bdb85307e4a@mail.gmail.com/
Also on:    postgresql.org/message-id/dcc563d10808071512j4f586afcld7782bdb85307e4a@mail.gmail.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: scott.marlowe@gmail.com, andrej.groups@gmail.com
  Subject: Re: file system and raid performance
  In-Reply-To: <dcc563d10808071512j4f586afcld7782bdb85307e4a@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox