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

From Bill Moran
Subject Re: Turning off atime on PostgreSQL DB volumes
Date
Msg-id 20070828135647.c63265f0.wmoran@potentialtech.com
Whole thread Raw
In response to Turning off atime on PostgreSQL DB volumes  ("Keaton Adams" <kadams@mxlogic.com>)
Responses Re: Turning off atime on PostgreSQL DB volumes  ("Gavin M. Roy" <gmr@myyearbook.com>)
List pgsql-general
In response to "Keaton Adams" <kadams@mxlogic.com>:

> 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?

I frequently run with noatime and have never noticed any problems.

--
Bill Moran
http://www.potentialtech.com

pgsql-general by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: Turning off atime on PostgreSQL DB volumes
Next
From: "Gavin M. Roy"
Date:
Subject: Re: Turning off atime on PostgreSQL DB volumes