Episode

Scaling the Wall of Text: Logging Best Practices in PostgreSQL

with Richard Yen

POSETTE: An Event for Postgres 2024

Video of a conference talk about logging best practices in PostgreSQL presented by Richard Yen at POSETTE: An Event for Postgres 2024. Something that many PostgreSQL users take for granted is the powerful logging features that it provides. With the right configuration, DBAs and sysadmins can quickly diagnose performance, security, and configuration issues, saving precious seconds of application uptime. This talk will cover the major logging parameters in postgresql.conf, as well as provide some tips and wisdom gleaned over years of parsing through gigabytes of logs.

Richard has been using PostgreSQL since v. 7.4 in 2003. He is a Principal Support Engineer at EnterpriseDB, providing technical support to DBAs and developers around the world, and works with many clients ranging from private corporations to government organizations and financial institutions.

Chapters

  • 00:00 - Intro
  • 01:15 - Why logging is important
  • 02:57 - Scenarios
  • 03:24 - What logging can tell you
  • 04:25 - PostgreSQL logging parameters
  • 04:48 - Where to log
  • 07:59 - What to log
  • 10:13 - When to log
  • 15:51 - What to log again
  • 18:55 - The importance of log_line_prefix
  • 23:23 - What to look for
  • 26:19 - Summary

Connect

Azure
Azure Database for PostgreSQL