To get the show notes as well as get notified of new episodes, visit:
[ Ссылка ]

In this episode of Scaling Postgres, we discuss slow WAL archival, index improvements coming for Postgres 13, accessing node metrics via SQL and deciding between a join or subquery.

Want to learn more about Postgres performance?
Join my FREE mini-course called the PostgreSQL Performance Starter Kit here: [ Ссылка ]

Timestamps:
00:00 - Intro
00:27 - Why PostgreSQL WAL Archival is Slow
04:54 - Index Improvements in PostgreSQL 13
05:39 - PostgreSQL 13Beta3: B-Tree index deduplication
06:22 - PostgreSQL Node Metrics: Don't Fly Blind
07:11 - Joins or Subquery in PostgreSQL: Lessons Learned
08:24 - Generating a normal distribution in SQL
08:53 - Which partition contains a specific row in my PostgreSQL database?
09:29 - FDWs, curl and LIMIT
10:43 - PG Phriday: 10 Things Postgres Could Improve – Part 3
13:12 - Postgres in the Cloud: The Hard Way
13:54 - [YouTube] Best Practices in Security with PostgreSQL
14:19 - Waiting for PostgreSQL 14 – Add support for partitioned tables and indexes in REINDEX
14:53 - Tuning PostgreSQL on ZFS
15:22 - Regina Obe
15:33 - Outro

#postgres #postgresql

свернуть