performance optimzations - Mailing list pgsql-performance

From Suchandra Thapa
Subject performance optimzations
Date
Msg-id 1068658430.1071.42.camel@hepcat
Whole thread Raw
Responses Re: performance optimzations
Re: performance optimzations
List pgsql-performance
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?

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.


--
Suchandra Thapa <s-thapa-11@alumni.uchicago.edu>

Attachment

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Seeking help with a query that takes too long
Next
From: Rod Taylor
Date:
Subject: Re: performance optimzations