PostgreSQL 9.0 Is Now Available

These two new features sound particularly interesting to me:<p>Streaming Replication: <a href="http://www.postgresql.org/docs/9.0/static/warm-standby.html#STREAMING-REPLICATION" rel="nofollow">http://www.postgresql.org/docs/9.0/static/warm-standby.html#...</a><p>Hot Standby: <a href="http://www.postgresql.org/docs/9.0/static/hot-standby.html" rel="nofollow">http://www.postgresql.org/docs/9.0/static/hot-standby.html</a>

What I really like about PostgreSQL compared to e.g. MySQL is the support for partial indexes (<a href="http://www.postgresql.org/docs/8.0/static/indexes-partial.html" rel="nofollow">http://www.postgresql.org/docs/8.0/static/indexes-partial.ht...</a>).<p>Especially when keeping normalized data, it allows the easy creation of an index without having the need to index ALL records and blow up the b+tree

Bit premature imho. The offical release day is tomorrow, and these kind of announcements only cause confusion and do no good for anyone.<p>But awesome job PG team, it's my favorite SQL server.

I really strongly dislike Phoronix. I don't know why it hasn't been replaced yet.

Any ideas when they plan to include materialized views? Last I checked it was part of this years GSoC.

Hello! What are the problems there have multimaster replication PostgreSQL v9? Is the problem solved update error, conflict, uniqueness, and delete?<p>Thank you.