pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Steve Poe <spoe@sfnet.cc>
To: performance pgsql <pgsql-performance@postgresql.org>
Subject: How to improve db performance with $7K?
Date: Fri, 25 Mar 2005 16:12:19 +0000
Message-ID: <42443863.4040302@sfnet.cc> (raw)

Situation:  An 24/7 animal hospital (100 employees) runs their business 
on Centos 3.3 (RHEL 3) Postgres 7.4.2 (because they have to) off a 2-CPU 
Xeon 2.8MHz, 4GB of RAM, (3) SCSI disks RAID 0 (zcav value 35MB per 
sec). The databse is 11GB comprised over 100 tables and indexes from 1MB 
to 2GB in size.

I recently told the hospital management team worst-case scenerio they 
need to get the database on its own drive array since the RAID0 is a 
disaster wating to happen. I said ideally a new dual AMD server with 
6/7-disk configuration would be ideal for safety and performance, but 
they don't have $15K.  I said a seperate drive array offer the balance 
of safety and performance.

I have been given budget of $7K to accomplish a safer/faster database 
through hardware upgrades.  The objective is to get a drive array, but I 
can use the budget any way I see fit to accomplish the goal.

Since I am a dba novice, I did not physically build this server, nor did 
I write the application the hospital runs on, but I have the opportunity 
to make it better, I'd thought I should seek some advice from those who 
have been down this road before.  Suggestions/ideas anyone?

Thanks.

Steve Poe



view thread (119+ messages)  latest in thread

Message-ID: <42443863.4040302@sfnet.cc>
Permalink:  ../42443863.4040302@sfnet.cc/
Also on:    postgresql.org/message-id/42443863.4040302@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
  Subject: Re: How to improve db performance with $7K?
  In-Reply-To: <42443863.4040302@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