pg_stat_statements track_planning | Postgres.FM 125 |
ฝัง
- เผยแพร่เมื่อ 10 ก.พ. 2025
- [ 🇬🇧_🇺🇸 Check out the subtitles - we now edit them, ChatGPT+manually! You can also try TH-cam's auto-translation of them from English to your language; try it and share it with people interested in Postgres!]
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 www.postgresql...
Our episode about pg_stat_statements postgres.fm/ep...
PostgreSQL 13.0 release notes www.postgresql...
track_planning causing performance regression (thread on hackers during v13 beta) www.postgresql...
Our episode on 4 million TPS postgres.fm/ep...
Observer effect in pg_stat_statements and pg_stat_kcache (Postgres TV Hacking session with Andrey and Kirk) www.youtube.co...
~~~
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 postgres.ai/
Michael Christofides, founder of pgMustard pgmustard.com/
~~~
This is the video version. Check out postgres.fm to subscribe to the audio-only version, to see the transcript, guest profiles, and more.
Waiting