Re: Turning off atime on PostgreSQL DB volumes

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Keaton Adams <kadams(at)mxlogic(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Turning off atime on PostgreSQL DB volumes
Date: 2007-08-28 17:51:29
Message-ID: 46D460A1.7000605@hagander.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Keaton Adams wrote:
> After reading several articles on the performance drag that Linux atime
> has on file systems we would like to mount our DB volumes with the
> noatime parameter to see just what type of a performance gain we will
> achieve. Does PostgreSQL use atime in any way when reading/writing
> data? If we turn off/disable atime on the DB volumes will that cause
> any type of issue at all with PostgreSQL 8.1 on Red Hat Enterprise Linux?

No, it shouldn't cause any issues. Just turn it off.

//Magnus

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bill Moran 2007-08-28 17:56:47 Re: Turning off atime on PostgreSQL DB volumes
Previous Message Tom Lane 2007-08-28 17:46:57 Re: Turning off atime on PostgreSQL DB volumes