pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Thomas F.O'Connell <tfo@sitening.com>
To: Steve Poe <spoe@sfnet.cc>
Cc: pgsql-performance@postgresql.org
Subject: Re: Follow-Up: How to improve db performance with $7K?
Date: Fri, 1 Apr 2005 03:09:50 -0500
Message-ID: <c6991bbd1f642296f117134a9aed7ad5@sitening.com> (raw)
In-Reply-To: <424CAB5D.9020807@sfnet.cc>
References: <42443863.4040302@sfnet.cc>
	<4244A90B.2030200@sfnet.cc>
	<42453273.2060509@turtle-entertainment.de>
	<200503261255.59007.josh@agliodbs.com>
	<42455DEC.2080301@sfnet.cc>
	<1112049794.23284.29.camel@localhost.localdomain>
	<424840AE.3050200@sfnet.cc>
	<1112107974.7903.28.camel@sixtyfour.internetstaff.com>
	<424CAB5D.9020807@sfnet.cc>

I'd use two of your drives to create a mirrored partition where pg_xlog 
resides separate from the actual data.

RAID 10 is probably appropriate for the remaining drives.

Fortunately, you're not using Dell, so you don't have to worry about 
the Perc3/Di RAID controller, which is not so compatible with Linux...

-tfo

  --
  Thomas F. O'Connell
  Co-Founder, Information Architect
  Sitening, LLC
  http://www.sitening.com/
  110 30th Avenue North, Suite 6
  Nashville, TN 37203-6320
  615-260-0005

On Mar 31, 2005, at 9:01 PM, Steve Poe wrote:

> Thanks for everyone's feedback on to best improve our Postgresql 
> database for the animal hospital. I re-read the PostgreSQL 8.0 
> Performance Checklist just to keep focused.
>
> We purchased (2) 4 x 146GB 10,000rpm SCSI U320 SCA drive arrays 
> ($2600) and (1) Sun W2100z dual AMD64 workstation with 4GB RAM 
> ($2500). We did not need a rack-mount server, so I though Sun's 
> workstation would do fine. I'll double the RAM. Hopefully, this should 
> out-perform our dual 2.8 Xeon with 4GB of RAM.
>
> Now, we need to purchase a good U320 RAID card now. Any suggestions 
> for those  which run well under Linux?
>
> These two drive arrays main purpose is for our database. For those 
> messed with drive arrays before, how would you slice-up the drive 
> array? Will database performance be effected how our RAID10 is 
> configured? Any suggestions?
>
> Thanks.
>
> Steve Poe




view thread (9+ messages)  latest in thread

Message-ID: <c6991bbd1f642296f117134a9aed7ad5@sitening.com>
Permalink:  ../c6991bbd1f642296f117134a9aed7ad5@sitening.com/
Also on:    postgresql.org/message-id/c6991bbd1f642296f117134a9aed7ad5@sitening.com

 · 

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: tfo@sitening.com, spoe@sfnet.cc
  Subject: Re: Follow-Up: How to improve db performance with $7K?
  In-Reply-To: <c6991bbd1f642296f117134a9aed7ad5@sitening.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