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.
JSON Home Improvement at SCALE 14x
Slides from my JSON Home Improvement talk at SCALE 14x are now live. Practical techniques for working with JSON in PostgreSQL.
A simple JSON difference function
Build a JSONB diff function in PostgreSQL using jsonb_each and a clever LEFT JOIN to find keys that exist only on the left or have diverging values.
Doing a bulk merge in PostgreSQL 9.5
PostgreSQL 9.5's new UPSERT syntax doesn't work with COPY, but you can achieve the same result using file_fdw to mount CSV files as foreign tables and combine…
Always Do This #3: Log Lock Waits and Temp Files
PostgreSQL logging is a balancing act, but two settings always earn their keep: log_lock_waits and log_temp_files.