Re: Hardware upgrade for a high-traffic database - Mailing list pgsql-performance

From Pierre-Frédéric Caillaud
Subject Re: Hardware upgrade for a high-traffic database
Date
Msg-id opscj2aygvcq72hf@musicbox
Whole thread Raw
In response to Hardware upgrade for a high-traffic database  ("Jason Coene" <jcoene@gotfrag.com>)
List 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 !

pgsql-performance by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: NUMERIC x VARCHAR
Next
From: Pierre-Frédéric Caillaud
Date:
Subject: Re: NUMERIC x VARCHAR