pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Steve Poe <spoe@sfnet.cc>
To: Joshua D. Drake <jd@commandprompt.com>
Cc: performance pgsql <pgsql-performance@postgresql.org>
Subject: Re: How to improve db performance with $7K?
Date: Sat, 26 Mar 2005 00:12:59 +0000
Message-ID: <4244A90B.2030200@sfnet.cc> (raw)
In-Reply-To: <4244B744.6020908@commandprompt.com>
References: <42443863.4040302@sfnet.cc>
	<4244B744.6020908@commandprompt.com>

You could build a dual opteron with 4 GB of ram, 12 10k raptor SATA 
drives with a battery backed cache for about 7k or less.

Okay. You trust SATA drives? I've been leary of them for a production 
database. Pardon my ignorance, but what is a "battery backed cache"?  I 
know the drives have a built-in cache but I don't if that's the same. 
Are the 12 drives internal or an external chasis? Could you point me to 
a place that this configuration exist? 

>
> Or if they are not CPU bound just IO bound you could easily just
> add an external 12 drive array (even if scsi) for less than 7k.
>
I don't believe it is CPU bound. At our busiest hour, the CPU is idle 
about 70% on average down to 30% idle at its heaviest. Context switching 
averages about 4-5K per hour with momentary peaks to 25-30K for a 
minute.  Overall disk performance is poor (35mb per sec).

Thanks for your input.

Steve Poe








view thread (119+ messages)  latest in thread

Message-ID: <4244A90B.2030200@sfnet.cc>
Permalink:  ../4244A90B.2030200@sfnet.cc/
Also on:    postgresql.org/message-id/4244A90B.2030200@sfnet.cc

 · 

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: spoe@sfnet.cc, jd@commandprompt.com
  Subject: Re: How to improve db performance with $7K?
  In-Reply-To: <4244A90B.2030200@sfnet.cc>

* 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