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 472186
To read all comments associated with this story, please click here.
Postgre is much nicer than mysql
by Alfman on Sat 7th May 2011 19:54 UTC
Alfman
Member since:
2011-01-28

Postgre is much more grown up than mysql. I frequently find myself pulling my hair out because of shortcomings of mysql and keep wishing I could use postgre in more hosted apps.

But mysql has become a defacto standard, and postgre isn't usually an option. It's very odd how the market chooses winners and losers, it rarely seems to be based on bringing the best product to market.

Sometimes postgre even rivals oracle in functionality. I don't expect an open source database to convert too many oracle clients, but it sure would be nice to phase out mysql.

Reply Score: 2

broken_symlink Member since:
2005-07-06

If you give oracle enough time i'm sure it will happen. They've run a bunch of sun's other projects into the ground already.

Reply Parent Score: 3

oiaohm Member since:
2009-05-30

Sometimes postgre even rivals oracle in functionality. I don't expect an open source database to convert too many oracle clients, but it sure would be nice to phase out mysql.


As budgets get tight a lot of companies are moving sideways. Not to pure postgresql but to Postgres Pus from enterprisedb. Its Oracle interface compatible.

Next lot of features will make the dual between Oracle and postgresql hotter. Replication has been Postgresql historic weakness when compared to oracle.

Yes the global down turn fuels open source.

Reply Parent Score: 2

Lennie Member since:
2007-09-22

PostgreSQL 9.0 already got the first of 2 parts of integrated replication support. Consistent, fast and efficient (Continuous Streaming Replication).

PostgreSQL 9.1 will add more replication support which means it will wait for the transaction data to be copied to the slave server before letting the application know the data has been committed (this is slower ofcourse, but is optional).

PG-Pool II also allows for queries to be load-balanced over the master and slave server and already worked with PostgreSQL 9.0

Slony-I allows for replication on a per table (and similair boundries).

Complete multi-master consistent read-/write-scaling of PostgreSQL has been available in seprate projects, like http://postgres-xc.projects.postgresql.org/ but has made it in to normal PostgreSQL yet.

Some commercial companies like: EnterpriseDB and Greenplum also sell products and support based around PostgreSQL or products which extended the abilties of PostgreSQL.

Reply Parent Score: 2