On Oct 17, 2008, at 2:19 PM, Brian Modra wrote:
Hi,
I have a server in production running postgresql, receiving 110 rows
inserted per second, with some pretty intense queries involving long
plpgsql.
This server has 4Gigs of RAM and dual processor. Disk is Raid 5.
I need more power, and am wondering what is the place really I need
to put more emphasis? CPU, RAM, or disk?
Monitoring what your performance bottlenecks are on the current system
(after tuning postgresql reasonably) is probably the best way to get
an answer to that for your workload.
I'm thinking of a 4xCPU and 20 Gigs and one of those large ram disks
which has its own battery and writes all RAM to hard disk in the
event of power failure.
Obviously I need to first get a good sysadmin guy to configure
postgres properly, but I am sure I also need a bigger host.
Any advice will be appreciated.
Tune first. Then monitor. Then think about what hardware changes (or
system configuration changes) might be worth looking at.
I'm betting that at that point you'll find the problem is disk I/O,
but it may turn out not to be.
RAID5 isn't considered well suited to typical database I/O, compared
to RAID10 or similar.
At the moment you have system logging, database WAL and database data
all competing for the same I/O, meaning the drives are probably
seeking a lot. Some ways around that are to use a decent disk
controller with a (battery-backed) writeback cache to aggregate
writes, or to divide your disk traffic across different disks - for
instance, a dedicated RAID pair for the database WAL.
Cheers,
Steve
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
