Скачать или смотреть What to log | Postgres.FM 147 |

[ 🇬🇧_🇺🇸 Check out the subtitles – we now edit them, ChatGPT+manually! You can also try YouTube's auto-translation of them from English to your language; try it and share it with people interested in Postgres!]

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/curre...
Our episode about Auditing https://postgres.fm/episodes/auditing
Our episode on auto_explain https://postgres.fm/episodes/auto_exp...

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?f...


~~~


What did you like or not like? What should we discuss next time? Let us know in the comments, or by tweeting us on @postgresfm   / postgresfm  , @samokhvalov   / samokhvalov   and @michristofides   / michristofides  


~~~


Postgres FM is produced by:
Nikolay Samokhvalov, founder of Postgres.ai https://postgres.ai/
Michael Christofides, founder of pgMustard https://pgmustard.com/


~~~


This is the video version. Check out https://postgres.fm to subscribe to the audio-only version, to see the transcript, guest profiles, and more.