BUFFERS by default episode artwork

EPISODE · Jul 29, 2022 · 33 MIN

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

Episode metadata supplied by the publisher feed · Published Jul 29, 2022

Embed this episode

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).

Distinct summary based on available episode metadata or transcript content.

NOW PLAYING

BUFFERS by default

0:00 33:58

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.

No similar episodes found.

No similar podcasts found.

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.

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. Use the download control on the episode player to save the publisher-provided media file.
URL copied to clipboard!