Here are links to a few things we mentioned:

  • EXPLAIN parameters (PostgreSQL documentation)
  • EXPLAIN (ANALYZE) needs BUFFERS (blog post by Nikolay)
  • Using BUFFERS for query optimization (blog post by Michael)
  • H3 indexes on PostGIS data (blog post by Ryan Lambert)
  • Turning BUFFERS on by default (latest patch)
  • pgMustard
  • explain.depesz.com
  • explain.dalibo.com
  • Database Lab Engine

What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov and @michristofides

If you would like to share this episode, here's a good link (and thank you!)

Postgres FM is brought to you by:

  • Nikolay Samokhvalov, founder of Postgres.ai
  • Michael Christofides, founder of pgMustard

With special thanks to:

  • Jessie Draws for the amazing artwork