Postgres Pro
Downloads
Home   >   mailing lists

Re: File systems (RE: Sanity check requested) - Mailing list pgsql-performance

From Tom Lane
Subject Re: File systems (RE: Sanity check requested)
Date
Msg-id 5893.1058564959@sss.pgh.pa.us
Whole thread Raw
In response to File systems (RE: Sanity check requested)  ("Nick Fankhauser" <nickf@ontko.com>)
List pgsql-performance
Tree view 
"Nick Fankhauser" <nickf@ontko.com> writes:
> I'm departing in three ways from the simple IDE
> model that (I presume) the default random page cost of 4 is based on- The
> disks are SCSI & RAID and the FS would be different.

Actually, the default 4 is based on experiments I did quite awhile back
on HPUX (with a SCSI disk) and Linux (with an IDE disk, and a different
filesystem).  I didn't see too much difference between 'em.  RAID might
alter the equation, or not.

            regards, tom lane

pgsql-performance by date:

Previous
From: Rod Taylor
Date:
Subject: Re: Sanity check requested
Next
From: Matthew Hixson
Date:
Subject: storing files in Postgres