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 24D47D1B565 for ; Wed, 12 Nov 2003 18:23:31 +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 39874-06 for ; Wed, 12 Nov 2003 14:23:00 -0400 (AST) Received: from mail.hive.nj2.inquent.com (mc.carriermail.com [205.178.180.9]) by svr1.postgresql.org (Postfix) with SMTP id D734BD1B561 for ; Wed, 12 Nov 2003 14:22:58 -0400 (AST) Received: (qmail 9143 invoked from network); 12 Nov 2003 18:22:58 -0000 Received: from unknown (HELO ?10.0.2.5?) (216.208.117.7) by 205.178.180.9 with SMTP; 12 Nov 2003 18:22:58 -0000 Subject: Re: performance optimzations From: Rod Taylor To: Suchandra Thapa Cc: Postgresql Performance In-Reply-To: <1068658430.1071.42.camel@hepcat> References: <1068658430.1071.42.camel@hepcat> Content-Type: text/plain Message-Id: <1068661380.30452.17.camel@jester> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 Date: Wed, 12 Nov 2003 13:23:01 -0500 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/73 X-Sequence-Number: 4633 On Wed, 2003-11-12 at 12:34, Suchandra Thapa wrote: > I'm moving a webmail service over to use a postgresql database for > storage and wanted to get any tips for optimizing performance. The > machine will be a multiprocessor (either 2 or 4 cpu ) system with a raid > array. What layout should be used? 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? How much in total storage? If you have (or will have) > ~6 disks, go for RAID 5 otherwise 10 is probably appropriate. > The database gets fairly heavy activity (the system handles about 500MB > of incoming and about 750MB of outgoing emails daily). I have a fairly > free rein in regards to the system's layout as well as how the > applications will interact with the database since I'm writing the > code. These are archived permanently -- ~450GB of annual data? Or is the data removed upon delivery?