X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.192]) by svr1.postgresql.org (Postfix) with ESMTP id 37785CCE04 for ; Fri, 18 Jul 2003 21:48:54 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr4.postgresql.org [64.117.224.192]) (amavisd-new, port 10024) with ESMTP id 45498-07 for ; Fri, 18 Jul 2003 21:49:23 +0000 (GMT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id AE878CCE1A for ; Fri, 18 Jul 2003 18:48:51 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h6ILnJQ3005894; Fri, 18 Jul 2003 17:49:19 -0400 (EDT) To: nickf@ontko.com Cc: "Pgsql-Performance@Postgresql. Org" Subject: Re: File systems (RE: Sanity check requested) In-reply-to: References: Comments: In-reply-to "Nick Fankhauser" message dated "Fri, 18 Jul 2003 09:31:46 -0500" Date: Fri, 18 Jul 2003 17:49:19 -0400 Message-ID: <5893.1058564959@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/306 X-Sequence-Number: 2599 "Nick Fankhauser" 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