Anmelden

Postgres FM· Folge 125

pg_stat_statements track_planning

Freitag, 29. November 2024 · 38 min

MP3

Shownotes

Nikolay and Michael discuss the track_planning parameter of pg_stat_statements — what it is, how it affects performance, and when or whether you should switch it on.

Here are some links to things they mentioned:
• pg_stat_statements.track_planning postgresql.org/docs/current/pgstatstatements.h…
• Our episode about pg_stat_statements postgres.fm/episodes/pg_stat_statements
• PostgreSQL 13.0 release notes postgresql.org/docs/release/13.0
• track_planning causing performance regression (thread on hackers during v13 beta) postgresql.org/message-id/flat/2895b53b033c47c…
• Our episode on 4 million TPS postgres.fm/episodes/four-million-tps
• Observer effect in pg_stat_statements and pg_stat_kcache (Postgres TV Hacking session with Andrey and Kirk) youtube.com/live/wHMNX-fHb2A?si=DPgmrPaSpPF6DxuS

~~~
What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, (postgres.fm/people) or by commenting on our Google doc (docs.google.com/document/d/1PNGSn_d0A7gTR4C0p6…)!

~~~
Postgres FM is produced by:
• Michael Christofides, founder of pgMustard (pgmustard.com)
• Nikolay Samokhvalov, founder of Postgres.ai (postgres.ai)

With special thanks to:
• Jessie Draws for the elephant artwork

Anmelden oder registrieren

Jetzt

0:00 / 0:00