X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id AD06ED1DD42 for ; Tue, 17 Feb 2004 22:17:15 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 68228-03 for ; Tue, 17 Feb 2004 18:17:13 -0400 (AST) Received: from tht.net (vista.tht.net [216.126.88.2]) by svr1.postgresql.org (Postfix) with ESMTP id 536BFD1DD1F for ; Tue, 17 Feb 2004 18:16:55 -0400 (AST) Received: from [134.22.68.145] (dyn-68-145.tor.dsl.tht.net [134.22.68.145]) by tht.net (Postfix) with ESMTP id 4F03676A90; Tue, 17 Feb 2004 17:17:00 -0500 (EST) Subject: Re: RAID or manual split? From: Rod Taylor To: Mike Glover Cc: Postgresql Performance In-Reply-To: <20040217135342.1924326f.mpg4@duluoz.net> References: <20040217135342.1924326f.mpg4@duluoz.net> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-80Mh6uoEnkX9riQR0X7U" Message-Id: <1077056235.18564.207.camel@jester> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 Date: Tue, 17 Feb 2004 17:17:15 -0500 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/246 X-Sequence-Number: 5770 --=-80Mh6uoEnkX9riQR0X7U Content-Type: text/plain Content-Transfer-Encoding: quoted-printable > There are frequent (100-1000/day) queries of both the > inventory and summary tables using the primary key -- always using the > index and returning < 10 rows. For this query frequency I don't think splitting the drives will do much -- you just need more IO. Look at optimizing the query themselves, specifically ensuring the useful information is already in memory. If the 10 rows are recent, you might try using partial indexes with the last days worth of information instead of an index across the entire table. > We're currently getting (barely) acceptable performance from a single > 15k U160 SCSI disk, but db size and activity are growing quickly.=20 > I've got more disks and a battery-backed LSI card on order. Configure for Raid 10 and you're off. --=20 Rod Taylor Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL PGP Key: http://www.rbt.ca/signature.asc --=-80Mh6uoEnkX9riQR0X7U Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (FreeBSD) iD8DBQBAMpLq6DETLow6vwwRAnRIAJ0Q3Wg89YwsG92J/zpuLAMR3rcFjACfQHJR Y+agrYG0movTSsjA7b7WRf8= =/NTI -----END PGP SIGNATURE----- --=-80Mh6uoEnkX9riQR0X7U--