What's new in PostgreSQL 9.0 - a User's Perspective

This is a wonderful upgrade that might finally convince some users to leave the mess that is MySQL behind.<p>It's been a long wait but replication is now finally as easy as it gets. And, by design, it can not silently lose or corrupt data. Unlike a certain other popular RDBMS.

another year, another release.<p>Thank you, everyone behind the development of PostgreSQL. I wouldn't be in my life where I am now if it wasn't for the work you are constantly putting into this wonderful project.<p>And when one thinks "now. this is it. it can't get any better now", you come out with another high-quality release.<p>Thank you ever so much.

I keep hoping that PostgreSQL will support an embedded version. SQLite only gets you so far, and it'd be nice to be able to ship PostgreSQL statically linked into your applications with zero-configuration at the user's end.<p>MySQL's working on this (<a href="http://mysql.com/oem/" rel="nofollow">http://mysql.com/oem/</a>), but I've read that PostgreSQL is way too tied to their multi-process network architecture for this to be feasible. But I'd love to be shown to wrong on that.

This is it. The final release that will put PostgreSQL ahead of MySQL in the performance and scalability realm. They've already exceeded or are at par with MySQL in single-box OLTP performance, now PostgreSQL can scale-out with read slaves. Other than entrenchment, there's very little justifiability in using any other RDBMS system (proprietary or open source) after 9.0 rolls out.

Postgres just keeps getting better. 8.4 was a fantastic release, too.<p>I don't know how they manage it, but every release adds features and becomes <i>more</i> stable. Pretty awesome job.

I've been wanting to use PostgreSQL. Does anyone know any good GUI tools for MacOS X for it?

Just once I'd like to have a discussion on HN about either MySQL or PostgreSQL without having a long thread about why one is more popular/better than the other. Not going to happen.

I know that cost and cross platform capabilities are big issues but for someone using MS SQL server express (free if database size &#60; 10 GB) in windows, are there any advantages that PostgreSQL has?

datapoint: I've been using PostgreSQL (and it's GIS extension PostGIS) with Rails for over a year now. Some minor issues along the way, but never ever going back to MySQL.

Does this release add any features that would keep you from going for a NoSQL solution? How does it for instance compare to MongoDB in terms of raw performance and scalability? (Not mentioning of course the difference in schema-less and relational design)