Mean vs p99 | Postgres.FM 148 | скачать в хорошем качестве

Mean vs p99 | Postgres.FM 148 |

[ 🇬🇧_🇺🇸 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!] Nik and Michael discuss looking at queries by mean time — when it makes sense, why ordering by p99 might be better, and the merits of approximating percentiles using the standard deviation. Here are some links to things they mentioned: Approximate the p99 of a query with pg_stat_statements (blog post by Michael) https://www.pgmustard.com/blog/approx... pg_stat_statements https://www.postgresql.org/docs/curre... Our episode about track_planning https://postgres.fm/episodes/pg-stat-... pg_stat_monitor https://github.com/percona/pg_stat_mo... statement_timeout https://www.postgresql.org/docs/curre... ~~~ 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.