UUID vs BIGSERIAL for Primary Keys
UUIDs cost slightly more than BIGSERIAL for inserts, but the performance hit is negligible—and they solve real problems like table merging and sharding that…
Beyond the B-Tree: GIST and GIN Indexes
Explore index types beyond PostgreSQL's default B-Tree. Learn when to reach for GiST, GIN, and BRIN indexes to solve real performance problems.
Django 1.8 and PostgreSQL at Djangocon 2015
Django 1.8 brings powerful new PostgreSQL features to your web framework. Discover what's new in our DjangoCon 2015 slides.
PostgreSQL and JSON: 2015
Slides from my PGConf US 2015 talk on JSON in PostgreSQL are now available for download.
Logical Decoding and JSON Talks at FOSDEM
Slides from talks on PostgreSQL logical decoding and JSON handling are now online.
When LIMIT attacks
PostgreSQL sometimes picks an unexpectedly slow index-based plan when a LIMIT clause is present, especially when column statistics don't reflect data…
“Be Very Afraid: Backup and Disaster Planning” at PGConf.EU
Slides from "Be Very Afraid: Backup and Disaster Planning" are now online. Learn how to protect your PostgreSQL data when things go wrong.
“Finding and Repairing Database Corruption” at PGConf.EU
Finding and repairing database corruption is tricky—here are the slides from a deep dive into detection and recovery techniques.
Why I prefer Python to Java, in two code samples.
Verify HTTPS connections against a custom root CA certificate instead of the system trust store.
Why I Resigned as Djangocon US 2014 Program Chair
A program chair's resignation from Djangocon US 2014 exposes organizational failures and interpersonal conflict that nearly derailed the conference.