pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Hardware opinions wanted
3+ messages / 3 participants
[nested] [flat]

* Hardware opinions wanted
@ 2004-05-27 22:40 Dan Harris <fbsd@drivefaster.net>
  2004-05-28 10:43 ` Re: Hardware opinions wanted Bjoern Metzdorf <bm@turtle-entertainment.de>
  0 siblings, 1 reply; 3+ messages in thread

From: Dan Harris @ 2004-05-27 22:40 UTC (permalink / raw)
  To: pgsql-performance

I wanted to solicit some opinions on architecture and performance from 
you guys.

I am torn right now between these two systems to replace my aging DB server:

4 x 2.2 GHz Opteron
8GB RAM
Ultra320 15kRPM RAID5 with 128MB cache

and

2-way 1.2GHz POWER4+ IBM pSeries 615
8GB RAM
Ultra320 15kRPM RAID5 with 64MB cache

I plan on serving ~80GB of pgsql database on this machine.  The current 
machine handles around 1.5 million queries per day.

I am having some trouble finding direct comparisons between the two 
architectures.  The OS will most likely be Linux ( I'm hedging on AIX 
for now ).  The pSeries has 8MB cache per CPU card ( 2 CPU on a card ) 
while the Opteron has 1MB for each processor.  I know the POWER4+ is a 
very fast machine but I wonder if having more processors in the Opteron 
system would beat it for database serving? FWIW, they are very close in 
price.

Ignoring the fault-tolerance features of the pSeries, which one would 
you pick for performance?

Thanks,
Dan



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Hardware opinions wanted
  2004-05-27 22:40 Hardware opinions wanted Dan Harris <fbsd@drivefaster.net>
@ 2004-05-28 10:43 ` Bjoern Metzdorf <bm@turtle-entertainment.de>
  2004-06-02 20:18   ` Re: Hardware opinions wanted Andrew Hammond <ahammond@ca.afilias.info>
  0 siblings, 1 reply; 3+ messages in thread

From: Bjoern Metzdorf @ 2004-05-28 10:43 UTC (permalink / raw)
  To: Dan Harris <fbsd@drivefaster.net>; +Cc: pgsql-performance

Dan Harris wrote:
> I am torn right now between these two systems to replace my aging DB 
> server:
> 
> 4 x 2.2 GHz Opteron
> 8GB RAM
> Ultra320 15kRPM RAID5 with 128MB cache
> 
> and
> 
> 2-way 1.2GHz POWER4+ IBM pSeries 615
> 8GB RAM
> Ultra320 15kRPM RAID5 with 64MB cache

I don't know anything about the pSeries, but have a look in the 
archives, there was recently a rather long thread about Xeon vs. 
Opteron. The Opteron was the clear winner.

Personally I think that you can't be wrong with the 4-way Opteron. It 
scales very well and if you don't need the fault tolerance of the 
pSeries platform, then you should be able to save one or two bucks with 
opteron way.

Btw: If you want to save a few more bucks, then drop the 15k and take 
10k drives. They are of almost same speed.

Regards,
Bjoern





^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Hardware opinions wanted
  2004-05-27 22:40 Hardware opinions wanted Dan Harris <fbsd@drivefaster.net>
  2004-05-28 10:43 ` Re: Hardware opinions wanted Bjoern Metzdorf <bm@turtle-entertainment.de>
@ 2004-06-02 20:18   ` Andrew Hammond <ahammond@ca.afilias.info>
  0 siblings, 0 replies; 3+ messages in thread

From: Andrew Hammond @ 2004-06-02 20:18 UTC (permalink / raw)
  To: Dan Harris <fbsd@drivefaster.net>; +Cc: Bjoern Metzdorf <bm@turtle-entertainment.de>; pgsql-performance

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I'm working through the aquisition process for a quad Opteron box right
now. I'll be benchmarking it against a quad processor p630 as well as a
quad Xeon after we get it and posting results here. But that's about a
month or two from now.

I expect that the results will be strongly in favour of the Opetron,
especially the price / performance since the Opteron box is being quoted
at about half the price of the p630 systems.

One thing you may wish to consider is going with lots of 10kRPM SATA
disks instead of 15kRPM SCSI disks. Two companies that I'm aware of
offer quad Opteron solutions with SATA raid:

http://www.quatopteron.com/
http://alltec.com/home.php

Andrew Hammond
DBA - Afilias
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFAvjYKgfzn5SevSpoRAvq0AJkBDXOKL52HXg43mQ6rXe/i9RzFkQCfYQn8
HpHP2U0jvjfYIvihNLFLbzA=
=LyqB
-----END PGP SIGNATURE-----



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2004-06-02 20:18 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-05-27 22:40 Hardware opinions wanted Dan Harris <fbsd@drivefaster.net>
2004-05-28 10:43 ` Bjoern Metzdorf <bm@turtle-entertainment.de>
2004-06-02 20:18   ` Andrew Hammond <ahammond@ca.afilias.info>

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