Scaling Postgres Episode 151 Cleaning | Function Performance | 11 Million IOPS | Change Data Capture

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 cleaning up your database, function performance, 11 million IOPS and change data capture.

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:26 - The Unexpected Find That Freed 20GB of Unused Index Space
04:12 - Cleaning Up Your Postgres Database
05:48 - Boost your User-Defined Functions in PostgreSQL
08:29 - Achieving 11M IOPS & 66 GB/s IO on a Single ThreadRipper Workstation
10:00 - Change Data Capture in Postgres With Debezium
10:49 - PostgreSQL: What is a checkpoint?
12:28 - [YouTube] EDB Channel
12:50 - Load and query Pi-hole data from Postgres
13:41 - PostgreSQL Database Security: Authentication
14:18 - Postgres and Crypto Supply Chain of Integrity
14:44 - Waiting for PostgreSQL 14 – SEARCH and CYCLE clauses
15:43 - How PostgreSQL Inserts A New Record With The help of Table Access Method API and Buffer Manager
16:02 - Using GitOps to Self-Manage Postgres in Kubernetes
16:17 - Various Ways to Retrieve Pgpool-II's Statistics
16:48 - OverlayNG and Invalid Geometry
17:19 - pg_timetable: asynchronous chain execution
17:33 - Alexander Sosna
17:46 - Outro

#postgres #postgresql