Re: Turning off atime on PostgreSQL DB volumes - Mailing list pgsql-general

From Magnus Hagander
Subject Re: Turning off atime on PostgreSQL DB volumes
Date
Msg-id 46D460A1.7000605@hagander.net
Whole thread Raw
In response to Turning off atime on PostgreSQL DB volumes  ("Keaton Adams" <kadams@mxlogic.com>)
List 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


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Turning off atime on PostgreSQL DB volumes
Next
From: Bill Moran
Date:
Subject: Re: Turning off atime on PostgreSQL DB volumes