From: Matthew Nuzum <matt.followers@gmail.com>
To: pgsql-performance@postgresql.org
To: 'Steve Poe' <spoe@sfnet.cc>
Subject: Re: Spend 7K *WHERE*? WAS Intel SRCS16 SATA raid? and How
Date: Fri, 15 Apr 2005 15:43:47 -0500
Message-ID: <42602785.602f27fb.2c70.0ad4@mx.gmail.com> (raw)
I think there are many people who feel that $7,000 is a good budget for a
database server, me being one.
* I agree with the threads that more disks are better.
* I also agree that SCSI is better, but can be hard to justify if your
budget is tight, and I have great certainty that 2x SATA drives on a good
controller is better than x SCSI drives for many work loads.
* I also feel that good database design and proper maintenance can be one
of the single biggest performance enhancers available. This can be labor
intensive, however, and sometimes throwing more hardware at a problem is
cheaper than restructuring a db.
Either way, having a good hardware platform is an excellent place to start,
as much of your tuning will depend on certain aspects of your hardware.
So if you need a db server, and you have $7k to spend, I'd say spend it.
From this list, I've gathered that I/O and RAM are your two most important
investments.
Once you get that figured out, you can still do some performance tuning on
your new server using the excellent advice from this mailing list.
By the way, for all those who make this list work, I've rarely found such a
thorough, helpful and considerate group of people as these on the
performance list.
--
Matthew Nuzum <matt@followers.net>
www.followers.net - Makers of "Elite Content Management System"
View samples of Elite CMS in action by visiting
http://www.followers.net/portfolio/
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: matt.followers@gmail.com, spoe@sfnet.cc
Subject: Re: Spend 7K *WHERE*? WAS Intel SRCS16 SATA raid? and How
In-Reply-To: <42602785.602f27fb.2c70.0ad4@mx.gmail.com>
* 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