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 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.
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.
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.