Column Performance, BRIN Win, Unique and Null, Parallel Distinct | Scaling Postgres 224

from Scaling Postgres · host Creston Jamison

In this episode of Scaling Postgres, we discuss how too many columns in a table can affect performance, at what point BRIN indexes win over btree, and Postgres 15 supporting unique nulls and parallel distinct queries. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/224-column-performance-brin-win-unique-null-parallel-distinct/

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

Embed this episode

Attribution link and audio player

Ready to play

Column Performance, BRIN Win, Unique and Null, Parallel Distinct | Scaling Postgres 224

0:00 13:57

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

Agile Plays Agile Plays For the past decade I have been working with scaling technology organizations who need to address the challenges of how to scale revenue, customer base, and employee headcount."Agile Plays" (http://agileplays.co.uk) are a set of strategies for scalability. Like a successful sports team you compile a set of strategies or “Plays”. These give potential solutions and the team chooses Plays as appropriate to gain advantage.

Frequently Asked Questions

How long is this episode of Scaling Postgres?

This episode is 13 minutes long.

When was this Scaling Postgres episode published?

This episode was published on July 18, 2022.

Can I download this Scaling Postgres episode?

Yes. Use the download control on the episode player to save the publisher-provided media file.

URL copied to clipboard!