PostgreSQL lets you name a table after built-in types like text, but it confuses the type system and can break pg_restore. Just don't.

Bridge PostgreSQL and Python with practical techniques shown at PyPgDay 2013.

Lose a single tablespace in PostgreSQL and you've lost your entire database. Tablespaces aren't optional storage—they're critical infrastructure.

A forgotten pg_hba.conf update broke streaming replication for weeks—but WAL archiving kept the standby current anyway. Here's why you need both.

You're a Django dev who inherited PostgreSQL duties. Here's what you actually need to know to survive and maybe even thrive.

AWS rolls out two new I/O offerings to tackle EBS performance woes, but neither is the silver bullet you might hope for.

pgbadger is a faster, more capable PostgreSQL log analyzer that handles complex logs pgfouine chokes on.

PostgreSQL expertise doesn't require it to be your full-time role—learn how to handle databases effectively as a Django developer.

When your business model depends on fighting the people you're supposed to serve, something has gone fundamentally wrong.

Your presentation from PGCon 2012 on running PostgreSQL on AWS is now available—no tears required.