Gehen Sie mit der App Player FM offline!
What to log
Manage episode 487217924 series 3369151
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!
~~~
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
157 Episoden
Manage episode 487217924 series 3369151
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!
~~~
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
157 Episoden
Alle Folgen
×Willkommen auf Player FM!
Player FM scannt gerade das Web nach Podcasts mit hoher Qualität, die du genießen kannst. Es ist die beste Podcast-App und funktioniert auf Android, iPhone und im Web. Melde dich an, um Abos geräteübergreifend zu synchronisieren.