Don’t stop with just learning all the index types in Postgres (BTree, Gin, GiST, Sp-GiST, KNN, conditional, functional) make sure you go further and check out this final in the installment of what happens when you issue a query and how indexes actually work under the covers.

Zalando’s Head of Data Engineering, Valentine Gogichashvili, shares their experiences with PostgreSQL and how it fared scaling up to 100 million visitors per month.

An EnterpriseDB survey showed 77% of users are dedicating all new deployments to PostgreSQL with 37% reporting they had migrated existing apps from Oracle or Microsoft SQL Server to Postgres.

CitusDB delivers real-time end user insights into your big data while reducing the cost and complexity of your database infrastructure and leveraging your existing PostgreSQL knowledge and applications. Supports structured or unstructured data and elastically scales.

If you want to use Postgres, but not run and maintain it yourself, Heroku or AWS are two compelling options. This is a thorough rundown of what you can expect from each.

Very deep technical stuff, tread with care.

Schemas are an often (but not always) awesome means for splitting up some data across different tables; think of them as good for lightweight sharding. But often when you split data up this way you want aggregate it up for some level of reporting, here’s a nice walk through of such.

A Python and Multicorn-based foreign data wrapper that brings together Neo4j and Postgres.

A small but handy utility if you’re in ops on how to grab the Postgres version and then potentially other information about it from within Go.

While it won’t be a magic bullet, this extension could certain add a ton of value and performance to your system by providing index recommendations for your databases.