Views are a way to represent the results of a query as a table, and materialized views actually create that data versus just running a query each time. They’re a great way to cache aggregate data when running an expensive query over time.

Citus Data’s cstore FDW offers a promising option for a columnar store in Postgres. Marco highlights some of the benefits, showing the storage space on disk of the powerful new JSONB datatype.

Barman (Backup and Recovery Manager) is an open source administration tool for disaster recovery of PostgreSQL servers written in Python.

The vast majority of questions arise during the deployment and maintenance phases of Postgres projects, not during development or POC. And with good reason - Postgres is an easy database to work with. But planning ahead for deployment and taking care of ongoing maintenance are the keys to success. Get prepared by reading Tales from The Trenches or improve performance with an Architectural Health Check.

Postgres is great as a reliable persistent store for data, but often in real-time/event focused systems people look to other options. But here’s a look at what integrating and blending those worlds together could look like through streaming Postgres WAL to Kafka.

A provoking and clearly thought out piece around the idea of moving much more code and logic directly into your database (something many DBAs will be nodding their heads about).

For many, Postgres is just the database behind their ORM, for others it becomes a powerful and unique tool, such as in this author’s situation when working with in the context of a GIS (geographic information system).

The JSON and JSONB datatypes are wonderful, but most people building apps aren’t writing raw SQL. Instead, you’re going through the ORM of whatever your chosen framework is, and if it hasn’t adapted yet you’re out of luck. Fortunately Rails 4 works great out of the box.