“Humans do not have a primary key” at PGOpen SV
Humans don't have primary keys. Learn why treating people as database records breaks down when you account for names, identity, and real-world complexity.
A brief reminder about casting TIMESTAMPTZ
Casting TIMESTAMPTZ to DATE gives different results depending on your client time zone—a subtle bug that can make identical queries return different dates.
Blog Moved.
The blog has moved to a new server. Here's what changed and what stayed the same.
shared_buffers is not a sensitive setting
Most shared_buffers tuning advice is overthinking it. Set it to 25% of system memory (max 32GB) and move on—the difference between 24GB and 32GB won't matter.
Resetting the postgres user’s password
Forgotten the postgres superuser password? Single-user mode lets you reset it without losing access to your database.
A PostgreSQL Response to Uber
Discover why Uber's infrastructure choices don't tell the whole story about PostgreSQL's capabilities and design tradeoffs.
“Corruption War Stories” from PGConf US 2017
Corruption War Stories from PGConf 2017 are now available. Learn what went wrong and how to prevent data corruption disasters.
“Django and PostgreSQL” from PGConf US 2017
Django and PostgreSQL presentation slides are now available for download from PGConf.
PostgreSQL When It’s Not Your Job
Your DBA is unavailable and PostgreSQL is down. Learn practical troubleshooting and operational basics from a PGConf US 2017 tutorial.
Corruption War Stories at PGDay FOSDEM 2017
Dive into real-world PostgreSQL corruption scenarios and how to recover from them.