Скачать или смотреть Scaling Postgres Episode 224 Column Performance, BRIN Win, Unique and Null, Parallel Distinct

To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episo...

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.

Want to learn more about Postgres performance?
Join my FREE mini-course called the PostgreSQL Performance Starter Kit here: https://www.scalingpostgres.com/cours...

Timestamps:
00:00 - Intro
00:27 - Column order in PostgreSQL does matter
03:02 - Postgres Indexing: When Does BRIN Win?
07:38 - Postgres 15 improves UNIQUE and NULL
08:43 - Introducing PostgreSQL 15: Working with DISTINCT
09:43 - 5mins of Postgres E26: New in Postgres 15 - NULL handling in UNIQUE constraints & Parallel DISTINCT
10:02 - PostgreSQL 14 Internals
10:32 - Pg-agent – a Postgres exporter for Prometheus focusing on query performance statistics
12:07 - State of PostgreSQL: How to Contribute to PostgreSQL and the Community
12:37 - Patroni and pgBackRest combined
12:57 - Charly Batista
13:09 - Rubber Duck Dev Show Episode 50 | Brittany Martin From The Ruby - On Rails Podcast
13:32 - Outro

#postgres #postgresql