On Nov 18, 2005, at 08:00, Dave Cramer wrote:
A $1,000 system with one CPU and two SATA disks in a software RAID0
perform exactly the same as a $80,000 system with 8 dual core CPUs
world's best SCSI RAID hardware on a large database for decision
(what the poster asked about).
Now there's an interesting line drawn in the sand. I presume you have
numbers to back this up ?
This should draw some interesting posts.
There is some truth to it. For an app I'm currently running (full-text
search using tsearch2 on ~100MB of data) on:
Asus bare-bones bookshelf case/mobo
3GHz P4 w/ HT
800MHz memory Bus
Fedora Core 3 (nightly update)
1 SATA Seagate disk (7200RPM, 8MB Cache)
worst-case query: 7.2 seconds
now, the machine I'm deploying to:
(4) 2.4GHz Xeons
533MHz memory bus
RedHat Enterprise 3.6
(5) 150000 RPM Ultra SCSI 320 on an Adaptec RAID 5 controller
same worst-case query: 9.6 seconds
Now it's not apples-to-apples. There's a kernel 2.4 vs. 2.6 difference
and the memory bus is much faster and I'm not sure what kind of context
switching hit you get with the Xeon MP memory controller. On a
previous postgresql app I did I ran nearly identically spec'ed machines
except for the memory bus and saw about a 30% boost in performance just
with the 800MHz bus. I imagine the Opteron bus does even better.
So the small machine is probably slower on disk but makes up for it in
single-threaded access to CPU and memory speed. But if this app were to
be scaled it would make much more sense to cluster several $800
machines than it would to buy 'big-iron'.
Bill McGonigle, Owner Work: 603.448.4440
BFC Computing, LLC Home: 603.448.1668
[EMAIL PROTECTED] Mobile: 603.252.2606
http://www.bfccomputing.com/ Pager: 603.442.1833
Jabber: [EMAIL PROTECTED] Text: [EMAIL PROTECTED]
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings