Artwork

Content provided by Michael Christofides and Nikolay Samokhvalov. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by Michael Christofides and Nikolay Samokhvalov or their podcast platform partner. If you believe someone is using your copyrighted work without your permission, you can follow the process outlined here https://ppacc.player.fm/legal.
Player FM - Podcast App
Go offline with the Player FM app!

What to log

48:34
 
Share
 

Manage episode 487217924 series 3369151
Content provided by Michael Christofides and Nikolay Samokhvalov. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by Michael Christofides and Nikolay Samokhvalov or their podcast platform partner. If you believe someone is using your copyrighted work without your permission, you can follow the process outlined here https://ppacc.player.fm/legal.

Nikolay and Michael discuss logging in Postgres — mostly what to log, and why changing quite a few settings can pay off big time in the long term.
Here are some links to things they mentioned:

Here are the parameters they mentioned changing:

  • log_checkpoints
  • log_autovacuum_min_duration
  • log_statement
  • log_connections and log_disconnections
  • log_lock_waits
  • log_temp_files
  • log_min_duration_statement
  • log_min_duration_sample and log_statement_sample_rate

And finally, some very useful tools they meant to mention but forgot to!

~~~

What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!

~~~

Postgres FM is produced by:

With credit to:

  • Jessie Draws for the elephant artwork
  continue reading

147 episodes

Artwork

What to log

Postgres FM

37 subscribers

published

iconShare
 
Manage episode 487217924 series 3369151
Content provided by Michael Christofides and Nikolay Samokhvalov. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by Michael Christofides and Nikolay Samokhvalov or their podcast platform partner. If you believe someone is using your copyrighted work without your permission, you can follow the process outlined here https://ppacc.player.fm/legal.

Nikolay and Michael discuss logging in Postgres — mostly what to log, and why changing quite a few settings can pay off big time in the long term.
Here are some links to things they mentioned:

Here are the parameters they mentioned changing:

  • log_checkpoints
  • log_autovacuum_min_duration
  • log_statement
  • log_connections and log_disconnections
  • log_lock_waits
  • log_temp_files
  • log_min_duration_statement
  • log_min_duration_sample and log_statement_sample_rate

And finally, some very useful tools they meant to mention but forgot to!

~~~

What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!

~~~

Postgres FM is produced by:

With credit to:

  • Jessie Draws for the elephant artwork
  continue reading

147 episodes

All episodes

×
 
Loading …

Welcome to Player FM!

Player FM is scanning the web for high-quality podcasts for you to enjoy right now. It's the best podcast app and works on Android, iPhone, and the web. Signup to sync subscriptions across devices.

 

Quick Reference Guide

Copyright 2025 | Privacy Policy | Terms of Service | | Copyright
Listen to this show while you explore
Play