Re: [GENERAL] Turning off atime on PostgreSQL DB volumes

2007-08-28 Thread Gavin M. Roy
We use noatime on our production database without issues. On 8/28/07, Bill Moran <[EMAIL PROTECTED]> wrote: > In response to "Keaton Adams" <[EMAIL PROTECTED]>: > > > After reading several articles on the performance drag that Linux atime > > has on file systems we would like to mount our DB volum

Re: [GENERAL] Turning off atime on PostgreSQL DB volumes

2007-08-28 Thread Bill Moran
In response to "Keaton Adams" <[EMAIL PROTECTED]>: > 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

Re: [GENERAL] Turning off atime on PostgreSQL DB volumes

2007-08-28 Thread Magnus Hagander
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/wr

Re: [GENERAL] Turning off atime on PostgreSQL DB volumes

2007-08-28 Thread Tom Lane
"Keaton Adams" <[EMAIL PROTECTED]> writes: > 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

[GENERAL] Turning off atime on PostgreSQL DB volumes

2007-08-28 Thread Keaton Adams
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/