Re: Hardware upgrade for a high-traffic database

From: Pierre-Frédéric Caillaud <lists(at)boutiquenumerique(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Hardware upgrade for a high-traffic database
Date: 2004-08-11 06:43:36
Message-ID: opscj2aygvcq72hf@musicbox
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


> We're currently running Postgres 7.4.1 on FreeBSD 5.2, a Dual Xeon 2.4,
> 2GB
> ECC, 3Ware Serial ATA RAID 5 w/ 4 disks (SLOW!!).

Cheap solution while you look for another server :

Try to use something other than RAID5.
You have 4 disks, so you could use a striping+mirroring RAID which would
boost performance.
You can switch with a minimum downtime (copy files to other HDD, change
RAID parameters, copy again...) maybe 1 hour ?
If your hardware supports it of course.
And tell us how it works !

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Pierre-Frédéric Caillaud 2004-08-11 06:47:10 Re: NUMERIC x VARCHAR
Previous Message Scott Marlowe 2004-08-11 06:21:48 Re: NUMERIC x VARCHAR