BRIN & Correlation, Poor Partitioning, 10 Beginner Tips, Table & Index Usage

Scaling Postgres

BRIN & Correlation, Poor Partitioning, 10 Beginner Tips, Table & Index Usage | Scaling Postgres 276

Jul 30 2023 | 00:15:57

00:00 / 00:15:57

Hosted By

Show Notes

In this episode of Scaling Postgres, we discuss the importance of correlation with BRIN indexes, how partitioning can kill performance, 10 tips for beginners and how to track table and index usage.

To get the show notes as well as get notified of new episodes, visit:

https://www.scalingpostgres.com/episodes/276-brin-correlation-poor-partitioning-10-beginner-tips-table-index-usage/

Other Episodes

Episode 223

July 10, 2022 • 00:14:59

Database Decomposition, Fast Text Search, Understanding pg_stat_activity, Window Functions | Scaling Postgres 223

In this episode of Scaling Postgres, we discuss the process of decomposing your database, how to search text in Postgres quickly, how to understand...

Episode 302

February 11, 2024 • 00:13:23

UUID vs Bigint Battle!!! | Scaling Postgres 302

In this episode of Scaling Postgres, we discuss when and how you should use UUIDs or not, how to optimize space with column order...

Episode 330

August 25, 2024 • 00:14:58

Splicing Elephant & Duck DNA | Scaling Postgres 330

In this episode of Scaling Postgres, we discuss the merging of Postgres and DuckDB via the pg_duckdb extension, how this can help the analytics...