Always Do This #1: Create New Clusters with Checksums
Always initialize PostgreSQL clusters with data checksums enabled to catch disk corruption early.
“The PCI-Compliant Database” at PGConfSV
Learn how to design a PostgreSQL database that meets PCI compliance requirements without sacrificing performance or usability.
Don’t Assume PostgreSQL is Slow
PostgreSQL's SERIAL can keep up with Redis for counters. Before adding caching layers, measure your actual bottlenecks—your intuition is probably wrong.
ProTip: Digital Ocean, Please Don’t Do This.
Hacktoberfest's t-shirt incentive flooded maintainers with low-quality pull requests, turning a well-meaning event into a nightmare of wasted review time.
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…