Postgres 9.4 is a year old now, and while we’ve covered many features we’ve given no lip service to this one. The filter clause allows you to show how many results were omitted my some clause, which for validating data or otherwise can be very handy.

Postgres 9.5 is due to land soon with a host of awesome features. The highlight will undoubtedly be 'upsert' - if you’re not familiar with it, this is a great primer.

Postgres 9.5 follows a recent trend of feature-packed releases for Postgres. Get the preview of what’s coming with the work in progress what’s new on the wiki, including: JSONB improvements, BRIN indexes, pg_rewind, and more.

This special 1-week course (Jan 11-15) combines the core topics from Foundations of Postgres Administration and Advanced PostgreSQL Administration, with significant savings over list price. It is designed for database professionals who are responsible for administration and maintenance of PostgreSQL. Register now - use promo code COMB-WEB-161 to get an additional 20% off.

Hopefully readers have no doubt that Postgres is a great option as a database, but sometimes Postgres outgrows a single node. At that point there’s a few options such as something like pg_shard or other data solutions such as Cassandra. This guide helps show where something like Cassandra might play in.

The list of options seem to keep growing for GUI editors for Postgres. dbHero looks to be a simple and clean option that looks great for OSX users.

Bidirectional replication isn’t extremely common, but allows for potential multi-master setups with Postgres. Though as highlighted here, there’s a few new ways you need to approach transactional semantics as you do put it in place.

If you’re running and managing your own Postgres instance chances are you want some dashboarding and tooling around it. If you don’t already have one setup or want to take a look at another pome is a simple but elegant dashboard for PG in Go.

The foundation for logical replication landed in Postgres 9.4, and now there’s a great solution to help you take advantage of it with plenty of supporting tooling.

Join the Heroku Data team and learn about supporting and operating database systems at scale.

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. Join today!