Re: Turning off atime on PostgreSQL DB volumes

[Magnus Hagander <magnus(at)hagander(dot)net>]

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