Post Content
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
? Let’s connect:
X – @PosetteConf https://x.com/PosetteConf
Mastodon – @posetteconf https://mastodon.social/@posetteconf
Threads – @posetteconf https://www.threads.net/@posetteconf
? Subscribe to the POSETTE News: https://aka.ms/posette-subscribe
? Slides for this talk: https://speakerdeck.com/richyen/2024-posette-logging
#PosetteConf #PostgreSQL #database
Presenters:
Richard Yen, EDB, Pricipal Support Engineer at EnterpriseDB
Connect:
Richard Yen: https://www.linkedin.com/in/richyen/ Read More Microsoft Developer
+ There are no comments
Add yours