BRIN indexes

from Postgres FM · host Nikolay Samokhvalov and Michael Christofides

Here are links to the two main resources we mentioned: Paul Ramsey's recent blog post on BRIN indexesTomas Vondra's slides on BRIN index improvementsA few other things we mentioned:B-tree Wikipedia page pg_repack pg_squeeze ------------------------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 21, 2022

Embed this episode

Attribution link and audio player

What this episode covers

Nikolay and Michael discuss BRIN indexes — how are they different to the default B-Tree index, when are they useful, and how they've improved in PostgreSQL 14.

Distinct summary based on available episode metadata or transcript content.

NOW PLAYING

BRIN indexes

0:00 36:07

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

No similar episodes found.

Similar Podcasts

No similar podcasts found.

Frequently Asked Questions

How long is this episode of Postgres FM?

This episode is 36 minutes long.

When was this Postgres FM episode published?

This episode was published on July 21, 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!