pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Marty Scholes <marty@outputservices.com>
To: pgsql-performance@postgresql.org
Subject: Re: Quad processor options
Date: Tue, 18 May 2004 21:38:25 -0600
Message-ID: <40AAD6B1.2030901@outputservices.com> (raw)

After reading the replies to this, it is clear that this is a 
Lintel-centric question, but I will throw in my experience.

 > I am curious if there are any real life production
 > quad processor setups running postgresql out there.

Yes.  We are running a 24/7 operation on a quad CPU Sun V880.

 > Since postgresql lacks a proper replication/cluster
 > solution, we have to buy a bigger machine.

This was a compelling reason for us to stick with SPARC and avoid 
Intel/AMD when picking a DB server.  We moved off of an IBM mainframe in 
1993 to Sun gear and never looked back.  We can upgrade to our heart's 
content with minimal disruption and are only on our third box in 11 
years with plenty of life left in our current one.

 > Right now we are running on a dual 2.4 Xeon, 3 GB Ram
 > and U160 SCSI hardware-raid 10.

A couple people mentioned hardware RAID, which I completely agree with. 
  I prefer an external box with a SCSI or FC connector.  There are no 
driver issues that way.  We boot from our arrays.

The Nexsan ATABoy2 is a nice blend of performance, reliability and cost. 
  Some of these with 1TB and 2TB of space were recently spotted on ebay 
for under $5k.  We run a VERY random i/o mix on ours and it will 
consistently sustain 15 MB/s in blended read and write i/o, sustaining 
well over 1200 io/s.  These are IDE drives, so they fail more often than 
SCSI, so run RAID1 or RAID5.  The cache on these pretty much eliminates 
the RAID5 penalties.

 > The 30k+ setups from Dell etc. don't fit our budget.

For that kind of money you could get a lower end Sun box (or IBM RS/6000 
I would imagine) and give yourself an astounding amount of headroom for 
future growth.

Sincerely,
Marty




view thread (25+ messages)

Message-ID: <40AAD6B1.2030901@outputservices.com>
Permalink:  ../40AAD6B1.2030901@outputservices.com/
Also on:    postgresql.org/message-id/40AAD6B1.2030901@outputservices.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: marty@outputservices.com
  Subject: Re: Quad processor options
  In-Reply-To: <40AAD6B1.2030901@outputservices.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