Скачать с ютуб Intro to query optimization | Postgres.FM 009 | в хорошем качестве

Intro to query optimization | Postgres.FM 009 |

Nikolay and Michael discuss query optimization — specifically for a single query, not at the system level. Here are links to a few things we mentioned: Using EXPLAIN (PostgreSQL documentation) https://www.postgresql.org/docs/curre... https://explain.depesz.com https://explain.dalibo.com pgMustard https://www.pgmustard.com/ EverSQL https://www.eversql.com/ pganalyze https://pganalyze.com/ pg_stat_monitor (Extension by Percona) https://github.com/percona/pg_stat_mo... Recent thread on hackers mailing list about plan_id in pg_stat_activity https://www.postgresql.org/message-id... auto_explain https://www.postgresql.org/docs/curre... EXPLAIN observer effect (Ongres blog post by Álvaro Hernández) https://ongres.com/blog/explain_analy... auto_explain overhead (blog post by Michael) https://www.pgmustard.com/blog/auto-e... pg_test_timing https://www.postgresql.org/docs/curre... Database Lab Engine (for thin clones) https://github.com/postgres-ai/databa... Our previous episode on BUFFERS https://postgres.fm/episodes/buffers-... EXPLAIN Explained (talk by Josh Berkus)    • EXPLAIN Explained   A beginner's guide to EXPLAIN (talk by Michael)    • A beginners guide to EXPLAIN ANALYZE – Mic...   A deeper dive into EXPLAIN (talk by Michael)    • A Deeper Dive into EXPLAIN   EXPLAIN glossary (pgMustard docs) https://www.pgmustard.com/docs/explain Topic suggestions document https://docs.google.com/document/d/1P... ----------------------- What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov   / samokhvalov   and @michristofides   / michristofides   ~~~ Postgres FM is brought to you by: Nikolay Samokhvalov, founder of Postgres.ai Michael Christofides, founder of pgMustard ~~~ This is the uncut version, with video. Check out https://Postgres.fm to find audio-only podcast episodes, edited for convenient listening.