Скачать с ютуб pg_stat_statements, Transaction ID Wraparound, Consultant Knowledge, CitusCon | Scaling Postgres 265 в хорошем качестве

pg_stat_statements, Transaction ID Wraparound, Consultant Knowledge, CitusCon | Scaling Postgres 265

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 different ways to use pg_stat_statements, how to handle transaction ID wraparound, consultant knowledge and all the videos of CitusCon. 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:28 - pg_stat_statements 00:58 - Queries for pg_stat_statements 02:20 - PGSQL Phriday #008 – pg_stat_statements 03:02 - pg_stat_statements PGSQLPhriday 03:36 - pg_stat_statement – Benefits and Shortcomings [PGSQL Phriday #008] 04:06 - Track performance differences with pg_stat_statements 04:44 - PGSQL Phriday #008: pg_stat_statements 05:00 - PGSQL Phriday #008 roundup and review! 05:14 - How to Fix Transaction ID Wraparound 07:50 - Should a consultant know everything? 09:55 - [YouTube] Citus Con: An Event for Postgres 2023 10:13 - PgBouncer 1.19.0 10:40 - Extracting the list of columns from the catalog 11:34 - The History of Slonik, the PostgreSQL Elephant Logo 12:29 - Various Restoration Techniques Using PostgreSQL Point-In-Time Recovery 13:13 - Postgres 16 highlight - JSON predicates 13:33 - Use PostgreSQL Domain rules to validate columns of data *missing link * 13:53 - Performance Tips Using Postgres and pgvector 14:41 - Forcing Join Order in Postgres Using Optimization Barriers 15:01 - Let’s party and upgrade PostgreSQL and PostGIS together 15:27 - How to submit a patch by email, 2023 edition 15:46 - Floor Drees 15:55 - Hotwires & Cookbooks With Andrea Rocca | Rubber Duck Dev Show 84 16:22 - Outro #postgres #postgresql