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

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

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.

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

Timestamps:
00:00 - Intro
00:44 - When Good Correlation is Not Enough
06:04 - Killing Performance with PostgreSQL Partitioning
07:41 - Partitioning in Postgres and the risk of high partition counts
08:00 - 10 Postgres tips for beginners
11:55 - Beginners Tips
12:06 - Effective PostgreSQL Monitoring: Utilizing the views pg_stat_all_tables and pg_stat_all_indexes PostgreSQL 16
13:04 - Remote Access Anything from Postgres
13:49 - PgBouncer 1.20 has been released
14:24 - Generated columns in PostgreSQL
14:50 - PostgreSQL can do what now?
15:16 - A PL/PgSQL Simple Roman Number Translator
15:31 - Outro

#postgres #postgresql

Тэги:

#PostgreSQL #Scaling_PostgreSQL #PostgreSQL_Performance

Скачать видео