Postgres 9.5 Release Notes (opens in new tab)

I'm just really happy about the allowing of update when inserts conflict. This will tidy a lot of code up for me and make writing in the future that much neater.

http://www.postgresql.org/docs/9.5/static/sql-insert.html

Anyone have ever built an application utilising row level security?

In old-school systems you normally have one database user and a connection pool set up in the app with that user. Row level access is handeld with join tables to sort out what data is accessible for the specific users (sent as parameter to most queries).

With row-level security you would crate a db-user for each application user and also its own connection pool?

Dupe: http://www.postgresql.org/about/news/1636/

I'm excited about the sorting improvements. Large index creation performance has been an embarrassment (I often have to defend pg against Oracle!), hopefully this will make things vastly better.