Linked by Jordan Spencer Cunningham on Wed 13th May 2009 01:18 UTC
Benchmarks Phoronix, known for their various speed tests and reviews, compared the latest in Ubuntu and what, until recently, used to be the lastest in Mac OS X with 29 different benchmarking tests. Some of the results were rather interesting.
Thread beginning with comment 363325
To read all comments associated with this story, please click here.
SQLite and PostgreSQL Performance
by Abacus_ on Wed 13th May 2009 10:40 UTC
Abacus_
Member since:
2006-12-08

Anyone any idea whether fsync() / fdatasync() does anything in Mac OS/X ? The large performance difference for the SQLite and PostgreSQL performance benchmarks made me wonder about this.

Reply Score: 2

christian Member since:
2005-07-06

It might be that MacOS X is not turning off hard drive write back cache, whereas Ubuntu is. The Ubuntu figures for SQLite come out at around 112 transactions per second (assuming each insert is 1 transaction) while MacOS X comes out at 500 transactions per second. The Ubuntu time is more consistent with a drive that has write back disabled.

Reply Parent Score: 2