A Cheap and Cheerful Replication Check
Monitor PostgreSQL replication lag with a simple timestamp table and cron job. This cheerful approach beats complex WAL math for many setups.
Securing PostgreSQL at PGConf EU
Talk slides from PGConf EU 2016 on securing PostgreSQL are now available. Learn practical strategies for hardening your database against common threats.
Unclogging the VACUUM at PGConf EU
The slides from "Unclogging the VACUUM" presentation at PGConf EU 2016 are now online. Learn how to keep PostgreSQL's cleanup process running smoothly.
Recent Slides
Mastering PostgreSQL across operations, compliance, and Python ecosystems: four talks on making Postgres work beyond the DBA role.
Always Do This #5: The Elements of postgresql.conf Style
Stop mixing postgresql.conf edits between the middle and the end of the file.
Indexes Are Not Cheap
More indexes don't always mean faster queries. Adding eight indexes to a test table slowed inserts by 14×, turning a 2-minute operation into 27 minutes.
Django 1.8/1.9 and PostgreSQL: An Ever-Closer Union
Learn how Django and PostgreSQL work together to build robust web applications, straight from the speaker at PyCon US 2016.
PostgreSQL High Availability, 2016 Edition
Slides from a PostgreSQL high-availability talk at FOSDEM 2016 are now available for download.
Always Do This #4: Put stats_temp_directory on a memory file system
Redirect PostgreSQL's statistics collector to a RAM disk and slash write I/O to your database volume. It's a free performance win that survives normal restarts.
PostgreSQL High Availability, 2016 Edition
High availability keeps PostgreSQL running when things go wrong—learn the strategies and tools that minimize downtime at PGDay 2016.