A talk from RubyConf AU 2017 that focuses on Postgres-oriented tips and tricks, including PostGIS and explain plans.

A common source of performance related problems is in Postgres’s ‘autovacuum’ system. Here’s a look at the basics of tuning it for your use case.

‘CREATE INDEX’ lets you specify ASC or DESC for each column being indexed, but why? A practical example here.

Does your company have a disaster recovery plan in place? More importantly, when's the last time you tested it? Don't risk experiencing severe data loss or down-time. Act pre-emptively & discover how Barman can help secure your critical databases.

A single row that shows stats about the background writer process’s activity.

A project from the PostGIS project that can break an address into its component parts.

How to build a PostgreSQL cluster using Kubernetes’ new StatefulSets feature.

Doing LIKE % queries for searches in your app? A better approach is Postgres’s full-text search functionality, as explained here.

Loren Sands-Ramshaw, author of GraphQL: The New REST, shows how to use GraphQL with multiple databases.

pg_pathman is a set of partitioning tools.

It’s like ‘diff’ but for PostgreSQL schemas.