Return of the BUFFERS

Nikolay and Michael return to the topic of BUFFERS for the third (and final?) time! They discuss the news that it'll be on by default with EXPLAIN ANALYZE in Postgres 18, and what effect that might have.

Here are some links to things they mentioned:
• Our first BUFFERS episode postgres.fm/episodes/buffers-by-default
• Our second BUFFERS episode postgres.fm/episodes/buffers-ii-the-sequel
• BUFFERS enabled for EXPLAIN ANALYZE by default (commit for Postgres 18) git.postgresql.org/gitweb/?p=postgresql.git;a=…
• explain.depesz.com/history
• Latency Numbers Every Programmer Should Know gist.github.com/jboner/2841832
• Twitter conversation about flushing caches x.com/prochazkafilip/status/1881655337499205736
• pg_buffercache_evict postgresql.org/docs/current/pgbuffercache.html…
• How to compare the quality of SQL query plans (blog post by Andrei Lepikhov) danolivo.substack.com/p/whose-optimisation-is-…
• We were added as PostgreSQL Contributors! postgresql.org/about/news/new-postgresql-contr…

~~~
What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, (postgres.fm/people) or by commenting on our Google doc (docs.google.com/document/d/1PNGSn_d0A7gTR4C0p6…)!

~~~
Postgres FM is produced by:
• Michael Christofides, founder of pgMustard (pgmustard.com)
• Nikolay Samokhvalov, founder of Postgres.ai (postgres.ai)

With special thanks to:
• Jessie Draws for the elephant artwork