Overhead of pg_stat_statements and pg_stat_kcache | Postgres.FM 084 |

[ 🇬🇧_🇺🇸 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 overhead of pg_stat_statements and pg_stat_kcache - mostly focusing on some interesting things Nikolay found while stress-testing some large spot instances up to and beyond 2m TPS(!)
Here are some links to things they mentioned:
pg_stat_statements www.postgresql...
pg_stat_kcache github.com/pow...
pg_stat_statements overhead estimate in pganalyze FAQs pganalyze.com/faq
What is the performance impact of pg_stat_statements? (DBA Stack Exchange answer with several links) dba.stackexcha...
Towards Millions TPS (blog post by Alexander Korotkov) akorotkov.gith...
Postgres.ai blog post with links to benchmarks postgres.ai/bl...
postgresql_cluster github.com/vit...
pg_wait_sampling github.com/pos...
pg_stat_kcache issue, discussion, and fast resolution github.com/pow...
log_statement_sample_rate postgresqlco.n...
auto_explain.sample_rate www.postgresql...
pg_stat_statements performance penalty on Intel much higher than on AMD gitlab.com/pos...
~~~
What did you like or not like? What should we discuss next time? Let us know in the comments, or by tweeting us on @samokhvalov / samokhvalov and @michristofides / michristofides
~~~
Postgres FM is brought to you 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 find the audio-only podcast version, available wherever you get your podcasts.

[@rosendo3219]

oh yeah, that fat sip of nice and cold beer before you start :)

[@NikolaySamokhvalov]

It was redbull
Not into beer really, but I like the idea -- maybe we should do some drinking late night online Postgres event (if Michael is drinking at all, idk)

[@pycontiki]

🤔 where has Nickolay been? Michael has been carrying the show for quite awhile. Hopefully Nickolay wasn’t in jail or anything bad 🤷🏻‍♂️🙄

[@NikolaySamokhvalov]

Jailbreak successfully applied.