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 472165
To view parent comment, click here.
To read all comments associated with this story, please click here.
pantheraleo
Member since:
2007-03-07

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


Keep in mind that out of the box, PostgreSQL is configured very conservatively, using extremely "safe" defaults. It's possible to greatly improve the performance by tuning it.

Reply Parent Score: 2

GatoLoko Member since:
2005-11-13

Keep in mind that out of the box, PostgreSQL is configured very conservatively, using extremely "safe" defaults. It's possible to greatly improve the performance by tuning it.


As I said, it was running an "optimized" config, or at least an attempt to it. Don't know how well tuned it is.

Reply Parent Score: 1

Lennie Member since:
2007-09-22

Was this on Windows without the use of persistent connections ? Because any of those 2 also slow it down in comparison to the opposite.

Reply Parent Score: 2