Linked by Jordan Spencer Cunningham on Wed 13th May 2009 01:18 UTC
Thread beginning with comment 363325
To read all comments associated with this story, please click here.
To read all comments associated with this story, please click here.
RE: SQLite and PostgreSQL Performance
by christian on Wed 13th May 2009 12:38
in reply to "SQLite and PostgreSQL Performance"
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.




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.