Trillions of Rows & Metrics | Scaling Postgres 359 скачать в хорошем качестве

Trillions of Rows & Metrics | Scaling Postgres 359

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 talk about indexes being added to Timescale's column store, processing 1 trillion metrics in Timescale, processing 1 trillion rows in Citus and partitions for deletion use cases. Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/cours... Timestamps: 00:18 - PostgreSQL Indexes for Columnstore: 1,185x Faster Lookup Queries, 224x Faster Inserts in TimescaleDB 02:48 - You, Too, Can Scale Postgres to 2 PB and 1 T Metrics per Day 03:30 - Speed Up Triggers by 7x With Transition Tables 04:08 - PostgreSQL: 1 trillion rows in Citus 05:41 - Citus: The Misunderstood Postgres Extension 08:15 - Postgres Troubleshooting: Fixing Duplicate Primary Key Rows 09:51 - GIN Indexes 12:07 - Snapshots 13:05 - Why PostgreSQL needs a better API for alternative table engines? 13:56 - SCaLE 22x, live streams and Row-Level Security Sucks 14:27 - Selective asynchronous commits in PostgreSQL - balancing durability and performance 16:05 - PostgreSQL 18: More granular log_connections 16:38 - Postgres Security Checklist from the Center for Internet Security 16:51 - Mentoring Applications and Hacking Workshop for April 2025 17:14 - Scaling Postgres Consulting Corner 18:06 - Outro #postgres #postgresql