Re: Turning off atime on PostgreSQL DB volumes

From: Bill Moran <wmoran(at)potentialtech(dot)com>
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:56:47
Message-ID: 20070828135647.c63265f0.wmoran@potentialtech.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In response to "Keaton Adams" <kadams(at)mxlogic(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrus 2007-08-28 17:56:55 Re: simple query runs 26 seconds
Previous Message Magnus Hagander 2007-08-28 17:51:29 Re: Turning off atime on PostgreSQL DB volumes