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 9FE74D1B557 for ; Thu, 13 Nov 2003 00:20:03 +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 05831-01 for ; Wed, 12 Nov 2003 20:19:34 -0400 (AST) Received: from node-4024d1a2.mdw.onnet.us.uu.net (nsit-s227-189.uchicago.edu [128.135.227.189]) by svr1.postgresql.org (Postfix) with ESMTP id 975DBD1B553 for ; Wed, 12 Nov 2003 20:19:30 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by node-4024d1a2.mdw.onnet.us.uu.net (Postfix) with ESMTP id D878E37D0A; Wed, 12 Nov 2003 18:15:58 -0600 (CST) Subject: Re: performance optimzations From: Suchandra Thapa To: Neil Conway Cc: pgsql-performance@postgresql.org In-Reply-To: <87oevh9q5x.fsf@mailbox.samurai.com> References: <1068658430.1071.42.camel@hepcat> <87oevh9q5x.fsf@mailbox.samurai.com> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-nUmlQp/VCc50mmNOJhgO" Organization: Message-Id: <1068682558.5193.47.camel@hepcat> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.2 (1.2.2-5) Date: 12 Nov 2003 18:15:58 -0600 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/79 X-Sequence-Number: 4639 --=-nUmlQp/VCc50mmNOJhgO Content-Type: text/plain Content-Transfer-Encoding: quoted-printable On Wed, 2003-11-12 at 16:29, Neil Conway wrote: > Suchandra Thapa writes: > > I was thinking using about using a raid 1+0 array to hold the > > database but since I can use different array types, would it be > > better to use 1+0 for the wal logs and a raid 5 for the database? >=20 > It has been recommended on this list that getting a RAID controller > with a battery-backed cache is pretty essential to getting good > performance. Search the list archives for lots more discussion about > RAID configurations. The server is already using a raid controller with battery backed ram and the cache set to write back (the server is on a ups so power failures shouldn't cause problems). I'll look at the list archives for RAID information.=20=20 --=20 Suchandra Thapa --=-nUmlQp/VCc50mmNOJhgO Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQA/ss0+6nShCjt5AZIRAj9GAJ9PQ3+CH11zo2zvQ3EXkD0pcE++ngCfSE8O +TjrbFQ0jBgOZmwkLFUVEIw= =5ZuI -----END PGP SIGNATURE----- --=-nUmlQp/VCc50mmNOJhgO--