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:

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?

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