From: Rod Taylor <pg@rbt.ca>
To: Suchandra Thapa <s-thapa-11@alumni.uchicago.edu>
Cc: Postgresql Performance <pgsql-performance@postgresql.org>
Subject: Re: performance optimzations
Date: Wed, 12 Nov 2003 13:23:01 -0500
Message-ID: <1068661380.30452.17.camel@jester> (raw)
In-Reply-To: <1068658430.1071.42.camel@hepcat>
References: <1068658430.1071.42.camel@hepcat>
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?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: pg@rbt.ca, s-thapa-11@alumni.uchicago.edu
Subject: Re: performance optimzations
In-Reply-To: <1068661380.30452.17.camel@jester>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox