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 https://postgres.fm/episodes/buffers-by-default
- Our second BUFFERS episode https://postgres.fm/episodes/buffers-ii-the-sequel
- BUFFERS enabled for EXPLAIN ANALYZE by default (commit for Postgres 18) https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=c2a4078ebad71999dd451ae7d4358be3c9290b07
- https://explain.depesz.com/history
- Latency Numbers Every Programmer Should Know https://gist.github.com/jboner/2841832
- Twitter conversation about flushing caches https://x.com/prochazkafilip/status/1881655337499205736
- pg_buffercache_evict https://www.postgresql.org/docs/current/pgbuffercache.html#PGBUFFERCACHE-PG-BUFFERCACHE-EVICT
- How to compare the quality of SQL query plans (blog post by Andrei Lepikhov) https://danolivo.substack.com/p/whose-optimisation-is-better
- We were added as PostgreSQL Contributors! https://www.postgresql.org/about/news/new-postgresql-contributors-3006
~~~
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 special thanks to:
- Jessie Draws for the elephant artwork