… SpecJAppServer benchmarks results which were published by PostgreSQL recently and which as Josh Puts it “This publication shows that a properly tuned PostgreSQL is… Benchmark Results List you would see MySQL Scores 720.56 and PostgreSQL scores 778.14 JOPS on 12 cores. This seems to show PostgreSQL…
Post: Watch out for Marketing benchmarks
August 23, 2006 By 7 Comments
Whenever I see benchmark results I try to understand if it is technical benchmark – made by people seeking the truth or it is… in everything, for example if I would do benchmarked of MySQL vs PostgreSQL and try my best to get best performance out… benchmark or recent CT benchmark are from this type. Interesting enough even in TPC or SPEC benchmarks vendors try to avoid directly comparable results…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… be very interesting to see for example results on the same hardware just running PostgreSQL instead of MySQL or having Sun box replaced with comparable Dell or HP box. Unfortunately such benchmarks are more… wishes to the Tom Daly and his team in further benchmark results improvements. I guess we’ll see more of these to…
Post: SysBench - benchmark tool
August 18, 2006 By 18 Comments
…vs RedHat stuff based on sysbench’s results (Peter and me provided performance consutling for …will write about in further notes. Regarding database benchmarks – in 0.4.7 and earlier versions…Sysbench supported only MySQL, but later Oracle and PostgreSQL (and deviations, e.g EnterpriseDB) were added -…
Post: MySQL/Innodb scalability tests after fix
January 3, 2007 By 1 Comment
… on it. I already wrote about interesting benchmarks Tweakers.net have done for MySQL and PostgreSQL with different CPUs. I was in… PostgreSQL 8.2 results Same as in previous test PostgreSQL is winner with large margin especially when it comes to higher concurrency. The results…
Post: How Percona strives to remain neutral and independent
March 21, 2011 By Leave a Comment
… product ran well on that benchmark but crashed on other simple queries is welcome to quote the benchmark results without mentioning the crashes… best fit. For example, we frequently refer people to expert PostgreSQL consultants when needed. We believe that people who need Percona…
Post: MySQL wins C'T Database Contest
August 29, 2006 By 27 Comments
Today MySQL published the press release with results of Database Contest (results on German available here http://www.mysql.de/ct-dbcontest… using Dell DVD Store benchmark (details available here: http://firebird.sourceforge.net/connect/ct-dbContest.html). Most interesting results are (more orders… opm PostgreSQL / PHP: 120 opm MySQL5/PHP on two boxes: 6000 opm. I wonder how C’T have got such low results…
Post: How to load large files safely into InnoDB with LOAD DATA INFILE
July 3, 2008 By 28 Comments
… these up. This is how you make InnoDB behave like PostgreSQL 
If the undo log space grows really big, it won…), key(col2) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 Here’s the result of loading the entire 4GB file in one chunk: time…
Comment: MySQL wins C'T Database Contest
August 31, 2006 By 27 Comments
… for PostgreSQL It does indeed looks strange. Especially if Oracle scores 1400. But this is simply to blame given implementation, not benchmarks. I’m quite sure large number of changes we’ve done would work on PostgreSQL as well such… fact as far as I remember PostgreSQL team had results analyses and they could get much better results after certain changes. Regarding time…
Comment: Star Schema Bechmark: InfoBright, InfiniDB and LucidDB
January 8, 2010 By 46 Comments
… to the erroneus results of PostgreSQL It should be mentioned that those were caused by a documented restriction in PostgreSQL wrt. to parsing… a while – see the PostgreSQL mailinglists for discussions of that “benchmark“). However I agree that this kind of benchmark is really geared towards…
