Re: File systems (RE: Sanity check requested)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: nickf(at)ontko(dot)com
Cc: "Pgsql-Performance(at)Postgresql(dot) Org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: File systems (RE: Sanity check requested)
Date: 2003-07-18 21:49:19
Message-ID: 5893.1058564959@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Nick Fankhauser" <nickf(at)ontko(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Matthew Hixson 2003-07-19 21:21:42 storing files in Postgres
Previous Message Rod Taylor 2003-07-18 19:12:47 Re: Sanity check requested