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

Some kind things our listeners have said