… of other databases and technologies in NoSQL and BigData space – PostgreSQL, EnterpriseDB, Hadoop,Hbase, MongoDB, CouchBase providing compliments and alternatives to…
Comment: Should you move from MyISAM to Innodb ?
March 27, 2013 By 59 Comments
… past MyISAM. Along with MySQL’s InnoDB, I also have PostgreSQL on my radar for future more critical web applications. I…
Post: MySQL and PostgreSQL SpecJAppServer benchmark results
July 25, 2007 By 13 Comments
… were published by PostgreSQL recently and which as Josh Puts it “This publication shows that a properly tuned PostgreSQL is not only… MySQL Scores 720.56 and PostgreSQL scores 778.14 JOPS on 12 cores. This seems to show PostgreSQL is some 10% faster… Fire X4100 available in Nov 2005 using Opteron 285 CPU, PostgreSQL benchmarks use Sun Fire X4200 M2 available in September 2006…
Post: Interesting MySQL and PostgreSQL Benchmarks
November 30, 2006 By 20 Comments
… much information about how MySQL or PostgreSQL was configured or about queries. Furthermore MySQL and PostgreSQL has a bit different implementations (ie… Xeon Woodcrest, Opteron and Niagra Pretty interesting to see how PostgreSQL scales just as systems should scale in theory – gradually goes…
Comment: Which adaptive should we use?
September 16, 2009 By 14 Comments
…_method What you say is feature for PostgreSQL only…. Do you prefer PostgreSQL to MySQL??? 
(PostgreSQL is one of the RDBMS which has… think you should not tune MySQL/InnoDB based on the PostgreSQL tuning knowledge…) Thank you
Post: Report from OSCON 2008
July 27, 2008 By 7 Comments
… crowd attending. Speaking about MySQL vs PostgreSQL it is worth to say PostgreSQL “owns” OSCON – The PostgreSQL booth had more engineers and large… and MySQL are largerly ignoring each other at the conference – PostgreSQL mentions Oracle, DB2 etc as the competitor they are after…
Comment: InnoDB Flushing: Theory and solutions
April 6, 2011 By 23 Comments
Kristian, PostgreSQL doesn’t have a checkpoint age target, but rather a … Smith’s benchmarks show that PostgreSQL is significantly prone to checkpoint stalls, so I think PostgreSQL needs a more sophisticated flushing and…
Comment: InnoDB Flushing: Theory and solutions
April 4, 2011 By 23 Comments
Kristian, PostgreSQL doesn’t have a checkpoint age target, but rather a … Smith’s benchmarks show that PostgreSQL is significantly prone to checkpoint stalls, so I think PostgreSQL needs a more sophisticated flushing and…
Comment: New OLAP Wikistat benchmark: Introduction and call for feedbacks
January 31, 2010 By 16 Comments
…, There are two factors: 1) I am not expert in PostgreSQL 2) Results, which directly compare PostregSQL vs MySQL, usually cause…, and one who presents them, is claimed unqualified a) in PostgreSQL, b) in MySQL, c) in both. So I do not… way. However if there is expert who wants to install PostgreSQL, tune it, and run proposed scenarios, I would be happy…
Comment: Star Schema Bechmark: InfoBright, InfiniDB and LucidDB
January 8, 2010 By 48 Comments
… the erroneus results of PostgreSQL It should be mentioned that those were caused by a documented restriction in PostgreSQL wrt. to parsing… when 8.3 was available for a while – see the PostgreSQL mailinglists for discussions of that “benchmark”). However I agree that…
