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 188674
To view parent comment, click here.
To read all comments associated with this story, please click here.
jayson.knight
Member since:
2005-07-06

That's the wrong list to look at, the TPC-C Price/Performance list is more accurate for real world scenarios (where price of the overall system is more of a factor):

http://www.tpc.org/tpcc/results/tpcc_price_perf_results.asp

The #6 system is a reasonable $27,500, and at ~18,000 transactions/minute is blistering fast for that price point.

The FAQ has more details (http://www.tpc.org/tpcc/faq.asp) and anyone is free to submit their own system for benchmarking. The only skewing factor is this point in the FAQ:

"Second, vendors choose to run benchmarks that provide their customer base with results relevant to those customers. Third, vendors may choose to run one benchmark over another because they believe one gives them better performance or price/performance than another benchmark."

Reply Parent Score: 3

carniz Member since:
2006-12-06

The #6 system is a reasonable $27,500, and at ~18,000 transactions/minute is blistering fast for that price point.

18,000 transactions/minute? It's not that much - our HP DL385 (using a low-end HP MSA1500) clocked 33,059 transactions/minute. This was with EnterpriseDB 8.1, btw. I guess it did cost a little more than $27,000 though..don't recall how much exactly.

Reply Parent Score: 1

steve_s Member since:
2006-01-16

It should be noted that there are currently no PostgreSQL benchmarks at all on the TPC list.

Reply Parent Score: 3

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