pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Suchandra Thapa <s-thapa-11@alumni.uchicago.edu>
To: pgsql-performance@postgresql.org
Subject: performance optimzations
Date: 12 Nov 2003 11:34:41 -0600
Message-ID: <1068658430.1071.42.camel@hepcat> (raw)

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>

Attachments:

  signature.asc (application/pgp-signature, 188B) download

view thread (8+ messages)  latest in thread

Message-ID: <1068658430.1071.42.camel@hepcat>
Permalink:  ../1068658430.1071.42.camel@hepcat/
Also on:    postgresql.org/message-id/1068658430.1071.42.camel@hepcat

 · 

reply

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: s-thapa-11@alumni.uchicago.edu
  Subject: Re: performance optimzations
  In-Reply-To: <1068658430.1071.42.camel@hepcat>

* 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