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.
Thread beginning with comment 472076
To read all comments associated with this story, please click here.
____________ (Insert applause here)
by poundsmack on Fri 6th May 2011 21:58 UTC
poundsmack
Member since:
2005-07-13

PostgreSQL is by far my favorite database to work with. The developers have done an amazing job, it's incredibly robust, stable, fast, and usually is light enough on recourses (though others are lighter). All in all, a very well rounded db. My first pick when starting a SQL project (followed by SQLite)

Reply Score: 5

Lennie Member since:
2007-09-22

Every time I want to use a SQL-database I come back to PostgreSQL, it easily is the most standard compliant, most consistent database of them all.

With PostgreSQL 9.1 it has built in replication, combined with pg_pool II or maybe the new replication features in PostgreSQL 9.2 it does everything 98% of the people would want or need.

Ohh, and it's free and open source. :-)

Some people use MySQL, I tried that, I don't want it anymore. They are now starting to add features again (like memcached compatible protocol support), which is good, competition is good.

Reply Parent Score: 5

GatoLoko Member since:
2005-11-13

Every time I want to use a SQL-database I come back to PostgreSQL, it easily is the most standard compliant, most consistent database of them all.


I've read the same thing a lot of times, but then I try to switch and find PostgreSQL a lot slower.

Try to run a basic Drupal 7 (for example) site with both databases on the same hardware and the speed difference is 2:1 comparing a default MySQL with an "optimized" PostgreSQL. I may have made some mistakes in the optimizations because I'm no expert on Postgre, but it's faster than the default config.

It would be nice to get better defaults, and a simplified "basic optimizations guide" of any kind.

The software may be the best, and the documentation may be good, but it lacks proper "starter/basic guides".

Edited: quoted the wrong section.

Edited 2011-05-07 02:26 UTC

Reply Parent Score: 1

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