Artwork

Innhold levert av Michael Christofides and Nikolay Samokhvalov. Alt podcastinnhold, inkludert episoder, grafikk og podcastbeskrivelser, lastes opp og leveres direkte av Michael Christofides and Nikolay Samokhvalov eller deres podcastplattformpartner. Hvis du tror at noen bruker det opphavsrettsbeskyttede verket ditt uten din tillatelse, kan du følge prosessen skissert her https://no.player.fm/legal.
Player FM - Podcast-app
Gå frakoblet med Player FM -appen!

What to log

48:34
 
Del
 

Manage episode 487217924 series 3369151
Innhold levert av Michael Christofides and Nikolay Samokhvalov. Alt podcastinnhold, inkludert episoder, grafikk og podcastbeskrivelser, lastes opp og leveres direkte av Michael Christofides and Nikolay Samokhvalov eller deres podcastplattformpartner. Hvis du tror at noen bruker det opphavsrettsbeskyttede verket ditt uten din tillatelse, kan du følge prosessen skissert her https://no.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

167 episoder

Artwork

What to log

Postgres FM

34 subscribers

published

iconDel
 
Manage episode 487217924 series 3369151
Innhold levert av Michael Christofides and Nikolay Samokhvalov. Alt podcastinnhold, inkludert episoder, grafikk og podcastbeskrivelser, lastes opp og leveres direkte av Michael Christofides and Nikolay Samokhvalov eller deres podcastplattformpartner. Hvis du tror at noen bruker det opphavsrettsbeskyttede verket ditt uten din tillatelse, kan du følge prosessen skissert her https://no.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

167 episoder

所有剧集

×
 
Loading …

Velkommen til Player FM!

Player FM scanner netter for høykvalitets podcaster som du kan nyte nå. Det er den beste podcastappen og fungerer på Android, iPhone og internett. Registrer deg for å synkronisere abonnement på flere enheter.

 

Hurtigreferanseguide

Copyright 2025 | Personvern | Vilkår for bruk | | opphavsrett
Lytt til dette showet mens du utforsker
Spill