What to log Podcast Por  capa

What to log

What to log

Ouça grátis

Ver detalhes do programa

Sobre este áudio

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:

  • What to log https://www.postgresql.org/docs/current/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHAT
  • Our episode about Auditing https://postgres.fm/episodes/auditing
  • Our episode on auto_explain https://postgres.fm/episodes/auto_explain


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!

  • https://pgpedia.info
  • https://postgresqlco.nf
  • https://why-upgrade.depesz.com/show?from=16.9&to=17.5


~~~

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:

  • Michael Christofides, founder of pgMustard
  • Nikolay Samokhvalov, founder of Postgres.ai


With credit to:

  • Jessie Draws for the elephant artwork

O que os ouvintes dizem sobre What to log

Nota média dos ouvintes. Apenas ouvintes que tiverem escutado o título podem escrever avaliações.

Avaliações - Selecione as abas abaixo para mudar a fonte das avaliações.