X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id C5DDCD1C93C for ; Tue, 29 Jul 2003 16:16:47 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 81404-02 for ; Tue, 29 Jul 2003 13:15:47 -0300 (ADT) Received: from isis.pcis.net (isis.pcis.net [207.18.226.3]) by svr1.postgresql.org (Postfix) with ESMTP id 8BA11D1C938 for ; Tue, 29 Jul 2003 13:16:45 -0300 (ADT) Received: from lyric.ofsloans.com (unverified [209.180.142.225]) by isis.pcis.net (Rockliffe SMTPRA 4.5.6) with ESMTP id ; Tue, 29 Jul 2003 11:16:44 -0500 Subject: Re: Tuning PostgreSQL From: Will LaShell To: Vivek Khera Cc: pgsql-performance@postgresql.org In-Reply-To: References: <873cgvpylu.fsf@stark.dyndns.tv> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-mI1xHXoPtwuwAT01kzv1" X-Mailer: Ximian Evolution 1.0.8 (1.0.8-11) Date: 29 Jul 2003 09:16:36 -0700 Message-Id: <1059495404.24884.69.camel@lyric.ofsloans.com> Mime-Version: 1.0 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/466 X-Sequence-Number: 2759 --=-mI1xHXoPtwuwAT01kzv1 Content-Type: text/plain Content-Transfer-Encoding: quoted-printable On Tue, 2003-07-29 at 08:14, Vivek Khera wrote: > >>>>> "GS" =3D=3D Greg Stark writes: >=20 > GS> "scott.marlowe" writes: >=20 > GS> But you have to actually test your setup in practice to see if it > GS> hurts. A big data warehousing system will be faster under RAID5 > GS> than under RAID1+0 because of the extra disks in the > GS> stripeset. The more disks in the stripeset the more bandwidth you > GS> get. >=20 > Anyone have ideas on 14 spindles? I just ordered a disk subsystem > with 14 high speed (U320 15kRPM) SCSI disks to hook up with a dell > PERC3/DC controller (only 128MB cache, though). Hey one comment on this. With dell Perc3/DC you should check the megaraid-devel list to find the best BIOS settings for maximum performance. There have been many comments on it and trials to get it going really well. All told though I totally love the LSI Megaraid ( which is what the perc3/dc is ) controllers. We use the Elite 1650 with seagate cheetah drives for a nice little array. --Will --=-mI1xHXoPtwuwAT01kzv1 Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQA/Jp3kZr3R5kgOZd0RAtT2AKCU52fTszZcAhAOKaB283ttetK9RACfQ3GF 0tg9nHoPcu5K/h1JmsJpJx4= =SrWT -----END PGP SIGNATURE----- --=-mI1xHXoPtwuwAT01kzv1--