Since there’s not a ton of out of the box easy to use solutions for HA Postgres, Compose has released a template for you to create your own custom fit high availability solution using etcd and Python.

When you delete a row in Postgres, it doesn’t actually delete, well it does eventually. When you delete a row it marks it as logically deleted, here’s how you can ensure it’s gone as well as a read on how it works with MVCC under the covers.

Discover a collaborative and entirely browser-based environment for your team's queries and data-driven insights. JackDB adds a security layer to your organization's entire data infrastructure. Try it for free.

JSONB arrived in Postgres 9.4 to a lot of excitement, but how does it really measure up? Here’s a look a performance, and how to really take advantage of it with the new operators which can utilize GIN indexes.

Foreign tables now present an even cleaner solution for partitioning your data with inheritance. While you’ll have to wait a little until 9.5 is available, this feature clearer can make the scale out process in Postgres a bit more comfortable for all.

First part of a series showing how we can sort items by popularity in a Ruby application following the Reddit style, using PostgreSQL and Elasticsearch.

Following on from a debate about the naming of Mapbox Vector Tiles, this post instead digs right into where they’re valuable and gets hands on with them. A great overview.

CStore - The fast and open source columnar store for analytics with PostgreSQL just received a new release which features some nice improvements. If you haven’t played with it yet, this is a good excuse.

Any article that starts off “PostgreSQL is so much more than a simple relational data store” makes me happy. A look at how Postgres is not only a great relational database, but can also work as a very solid queue for your application.