Postgres 9.5’s headline features include UPSERT, row level security, and extra ‘big data’ features like BRIN indexing, improved foreign data wrappers, and TABLESAMPLE, an SQL clause for statistical sampling of large tables.
If you’re looking to take Postgres 9.5 for a spin and down want to spin it up yourself on a server, Heroku has an answer. Supporting 9.5 on its beta release day, a single click can bring you a 9.5-powered database to explore.
A few years back MySQL had a few legs up on Postgres with simple replication setup, upsert… but now that list of missing features is virtually nonexistent. So with Postgres moving not just to feature parity but beyond, here’s some good speculation on what the future might hold.
Indeed Prime is an elite new program from Indeed.com that presents
in-demand tech talent like you to top employers. Indeed Prime opens
the door to exciting career opportunities with one simple application.