| From: | Rod Taylor <pg(at)rbt(dot)ca> |
|---|---|
| To: | Suchandra Thapa <s-thapa-11(at)alumni(dot)uchicago(dot)edu> |
| Cc: | Postgresql Performance <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: performance optimzations |
| Date: | 2003-11-12 18:23:01 |
| Message-ID: | 1068661380.30452.17.camel@jester |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nick Fankhauser | 2003-11-12 18:27:53 | Re: Seeking help with a query that takes too long |
| Previous Message | Suchandra Thapa | 2003-11-12 17:34:41 | performance optimzations |