PostgreSQL 9.4 Beta 1 Released

I have an 8TB database with 10 bn rows, each with multiple json columns where most of the real data is stored... so jsonb day is like christmas for me.

After playing around in nosql land for the last 3 years I&#x27;ve landed at postgresql as my go-to sql alternative although the market will keep being fragmented.<p>edit: json support in combination with a less fanatic approach to normalization can approximate some of the benefits a nosql model can while maintaining the bulk of the tried-and-tested flows in a relational database.

Postgresql is getting better and better! I am happy lately every release has some more feature &#x2F; improvement about replication.

looking especially forward to JSONB, the extended array manipulation functions and the improved GIN index!

non blocking refresh on materialized views is going to be massive! I wonder when it&#x27;s going GA and Heroku rollout.

When is PostgreSQL going to get its own modern language which is functional&#x2F;object-oriented&#x2F;homoiconic&#x2F;has-all-new-fangled-goodies built in, with a GUI language thrown in for good measure, so I can do everything in PostgreSQL without having to turn to another language?

Going to be such a great release. Congrats PostgreSQL team! I love your product!

I&#x27;m particularly excited about improvements in materialised views that will make Postgresql better suited to OLAP usage scenarios.

pg_prewarm looks interesting but the docs are currently a little opaque as to how best to use it (for me at least!): <a href="http://www.postgresql.org/docs/devel/static/pgprewarm.html" rel="nofollow">http:&#x2F;&#x2F;www.postgresql.org&#x2F;docs&#x2F;devel&#x2F;static&#x2F;pgprewarm.html</a>

&quot;ALTER SYSTEM SET, which enables modifications to postgresql.conf from the SQL command line and from remote clients, easing administration tasks&quot;<p>This is fantastic. We&#x27;re always adding and removing ip addresses and restarting the server with each update was a pain.

The refresh concurrently materialized views is huge. I am glad that it was introduced since I currently have to use tables with functions to create&#x2F;drop to get the same functionality.

Am I right in saying that JSONB is another way to say BSON?

waiting for upset improvement.

With 9.4, what will be the best option for multi-master replication? Will 3rd party tools like bucardo remain the preferred method, or will there be another strategy that is more integrated with PG?