05:35Scaling the Wall of Text: Logging Best Practices in PostgreSQL | POSETTE 2024
From the creator
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 📕 Everything you need to know about POSETTE: An Event for Postgres 2024 can be found at: https://aka.ms/posette ✅ Learn more: Watch more POSETTE talks: https://aka.ms/posette-playlist-2024 📌 Let’s connect: X – @PosetteConf https://x.com/PosetteConf Mastodon - @posetteconf https://mastodon.social/@posett
Published 2024-06-13 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.





