Linked by Eugenia Loli on Wed 6th Dec 2006 00:40 UTC
Databases PostgreSQL 8.2 is now released (sources, binaries) while you can read the release notes here.
Thread beginning with comment 188992
To view parent comment, click here.
To read all comments associated with this story, please click here.
RE[4]: PostgreSQL 8.2 Benchmarks
by kjn9 on Thu 7th Dec 2006 00:44 UTC in reply to "RE[3]: PostgreSQL 8.2 Benchmarks"
kjn9
Member since:
2006-01-17

The TPC-C benchmark spec, and the full report on one of the benchmarks, make interesting reading.

Taking the Dell PowerEdge at position 2 in the list, the most expensive component, at 53% of the total cost, is the SCSI disk subsystem, with 56 SCSI drives, each 36 Gb, in a RAID 0 configuration. The benchmark spec requires 60 days' data to be stored, so storage is always going to be a major part of the expense. The MS software licenses and support are only 18% of the total cost of the system. The requirement for 3 years 24 x 7 support appears to have been interpreted liberally for the MS software, as "one incident" at $245.

The benchmark is designed for a DB running orders, payments and warehousing for a business - quite a large business, if it is processing tens of thousands of transactions per minute.

Many of us will be interested in a different workload, where ACID and RAID are essential, but a pair of disks will suffice, and writes are much less frequent than reads - as the backend of CMS or web hosting facility, for example.

For such a workload, we really need a different benchmark. The price advantage of PostgreSQL will make a much bigger difference to the final performance/price ratio.

Reply Parent Score: 2