Every Friday and Sunday, Slate’s popular daily news podcast What Next brings you TBD, a clear-eyed look into the future. From fake news to fake meat, algorithms to augmented reality, Lizzie O’Leary is your guide to the tech industry and the world it’s creating for us to live in.
…
continue reading
MP3•Episode home
Manage episode 520483934 series 3369151
Content provided by Michael Christofides and Nikolay Samokhvalov. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by Michael Christofides and Nikolay Samokhvalov or their podcast platform partner. If you believe someone is using your copyrighted work without your permission, you can follow the process outlined here https://staging.podcastplayer.com/legal.
Nik and Michael discuss the various changes to EXPLAIN that arrived in Postgres 18.
Here are some links to things they mentioned:
- EXPLAIN (official docs) https://www.postgresql.org/docs/current/sql-explain.html
- Using EXPLAIN (official docs) https://www.postgresql.org/docs/current/using-explain.html
- EXPLAIN glossary (pgMustard site) https://www.pgmustard.com/docs/explain
- Postgres 18 release notes https://www.postgresql.org/docs/release/18.0/
- Enable BUFFERS with EXPLAIN ANALYZE by default (commit) https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=c2a4078eb
- Our (first) BUFFERS by default episode https://postgres.fm/episodes/buffers-by-default
- Show index search count in EXPLAIN ANALYZE (commit) https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=0fbceae841cb5a31b13d3f284ac8fdd19822eceb
- Our episode on Skip scan with Peter Geoghegan https://postgres.fm/episodes/skip-scan
- What do the new Index Searches lines in EXPLAIN mean? https://www.pgmustard.com/blog/what-do-index-searches-in-explain-mean
- pg_stat_plans presentation by Lukas Fittl https://www.youtube.com/watch?v=26coQV3f-wk
- Improve EXPLAIN's display of window functions (commit) https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=8b1b34254
- Show Parallel Bitmap Heap Scan worker stats in EXPLAIN ANALYZE (commit) https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=5a1e6df3b
- Add information about WAL buffers being full (commit) https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=320545bfc
~~~
What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!
~~~
Postgres FM is produced by:
- Michael Christofides, founder of pgMustard
- Nikolay Samokhvalov, founder of Postgres.ai
With credit to:
- Jessie Draws for the elephant artwork
165 episodes