BUFFERS by default

from Postgres FM · host Nikolay Samokhvalov and Michael Christofides

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.comexplain.dalibo.comDatabase Lab Engine------------------------What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov and @michristofidesIf 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.aiMichael Christofides, founder of pgMustardWith special thanks to:Jessie Draws for the elephant artwork

What this episode covers

Nikolay and Michael discuss BUFFERS — what they are, how they can be very useful for query optimisation, and whether they should be on by default (spoiler alert, we think they should).

NOW PLAYING

BUFFERS by default

0:00 33:58

1×

No transcript for this episode yet

We transcribe on demand. Request one and we'll notify you when it's ready — usually under 10 minutes.

Share this episode

Similar Episodes

November 30, 2025 - Unity through Service: A conversation with ACAO executive officer Hector Addison

Dec 12, 2025 ·23m

November 27, 2025 - A conversation with UOSU's President Jack Coen

Dec 4, 2025 ·32m

October 30, 2025 - AI: Yay or Nay?

Nov 8, 2025 ·36m

October 16, 2025 - Why are fewer young men enrolling in post-secondary education?

Oct 16, 2025 ·34m

October 2, 2025 - Chrystia Freeland resigns from cabinet and is appointed to new Ukraine envoy role

Oct 5, 2025 ·25m

September 18, 2025 - How Labubus took over your feed

Sep 18, 2025 ·26m

Similar Podcasts

Frag Big Moes Mama 98.8 KISS FM Big Moes Mama ist genauso crazy wie ihr Sohn und ab sofort part of the podcast family! Ab jetzt jeden Dienstag ab 22 Uhr auf KISS FM in der Podcast Happy Hour: Frag Big Moe’s Mama! Big Moe und seine Mama beantworten gemeinsam alle möglichen Fragen aus der KISS Nation. Jedes Thema ist willkommen. Natürlich nutzt Big Moe’s Mama jede Möglichkeit, um diverse peinliche Geschichten aus Big Moe’s Leben zu erzählen! Was für Big Moe auch mal sehr unangenehm werden kann. Tune in! Behind The X 102.5 KNIX (KNIX-FM) An all access pass to Arizona's #1 Country station. Hear the behind-the-scenes content and interviews from 102.5 KNIX! HealthCall LIVE WOWO / Federated Media HealthCall LIVE with Lee Kelso is a summary of the weeks most interesting and useful health and medical news. Lee Kelso is a veteran TV news anchor, radio journalist and host of viewer-driven, health-focused TV and online broadcasts. Each week, he brings you a series of interesting health news headlines and medical breakthroughs collected from professional journals and research projects around the world. You can also listen to HealthCall LIVE at 7am Tuesday mornings and 9-10am Saturday mornings on News/Talk 1190 WOWO 107.5 FM in Fort Wayne. The Math Factor C Goodman-Strauss Kyle Kellams A brief, weekly math conversation and puzzle, airing on KUAF 91.3 FM, Fayetteville Arkansas. Send your answers, comments, questions, puzzles, or cash, to [email protected]!

Frequently Asked Questions

How long is this episode of Postgres FM?

This episode is 33 minutes long.

When was this Postgres FM episode published?

This episode was published on July 29, 2022.

What is this episode about?

Is there a transcript available for this episode?

Yes, a full transcript is available for this episode. You can read the complete transcript on the episode page.

Can I download this Postgres FM episode?

Yes, you can download this episode by clicking the download button on the episode player, or subscribe to the podcast in your preferred podcast app for automatic downloads.

URL copied to clipboard!