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 9EF9AD1B53F for ; Wed, 12 Nov 2003 18:55:43 +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 40919-09 for ; Wed, 12 Nov 2003 14:55:13 -0400 (AST) Received: from node-4024d1a2.mdw.onnet.us.uu.net (nsit-s229-45.uchicago.edu [128.135.229.45]) by svr1.postgresql.org (Postfix) with ESMTP id C6ABDD1B502 for ; Wed, 12 Nov 2003 14:55:04 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by node-4024d1a2.mdw.onnet.us.uu.net (Postfix) with ESMTP id AC60D37D0A; Wed, 12 Nov 2003 12:51:10 -0600 (CST) Subject: Re: performance optimzations From: Suchandra Thapa To: Rod Taylor Cc: Postgresql Performance In-Reply-To: <1068661380.30452.17.camel@jester> References: <1068658430.1071.42.camel@hepcat> <1068661380.30452.17.camel@jester> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-RPIt6DKUfon9QoHE8LNb" Organization: Message-Id: <1068663070.5193.21.camel@hepcat> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.2 (1.2.2-5) Date: 12 Nov 2003 12:51:10 -0600 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/75 X-Sequence-Number: 4635 --=-RPIt6DKUfon9QoHE8LNb Content-Type: text/plain Content-Transfer-Encoding: quoted-printable On Wed, 2003-11-12 at 12:23, Rod Taylor wrote: > 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? >=20 > How much in total storage? If you have (or will have) > ~6 disks, go > for RAID 5 otherwise 10 is probably appropriate. I'm not sure but I believe there are about 6-8 10K scsi drives on the system. There is quite a bit of storage to spare currently so I think=20 > > 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. >=20 > These are archived permanently -- ~450GB of annual data? Or is the data > removed upon delivery? No, it's more like hotmail. Some users may keep mail for a longer term but a lot of the mail probably gets deleted fairly quickly. The database load will be mixed with a insertions due to deliveries, queries by the webmail system, and deletions from pop and webmail. --=20 Suchandra Thapa --=-RPIt6DKUfon9QoHE8LNb 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/soEe6nShCjt5AZIRAt21AKCFSDhmJ7O/Q/vm1UM3+b9PKM4XggCeOI7K naNwR0tmY5gOldNONquIAzc= =WvjL -----END PGP SIGNATURE----- --=-RPIt6DKUfon9QoHE8LNb--