Linked by Thom Holwerda on Fri 6th May 2011 21:00 UTC
Databases The release of the first beta of version 9.1 of the open source PostgreSQL database has opened a new era in enterprise-class reliability and data integrity that can compete with the big names, say its developers. CIO recently interviewed Josh Berkus, Kevin Grittner, Dimitri Fontaine and Robert Haas about PostgreSQL 9.1 and its future.
Permalink for comment 472312
To read all comments associated with this story, please click here.
unoengborg
Member since:
2005-07-06

As long as you do simple things like "select * from table" type of queries MySQL is often faster then Postgresql, but as things get more complicated with a couple of joins, or things like relational division Postgresql often is faster. My guess is that Drupal is designed with that in mind, meaning that you do the heavly lifting in PHP instead of in the database, and thus can't make use of the additional speed Postgresql offer you.

Reply Parent Score: 2