pg_failover_slots, Standby Logical Decoding, Trusted Language Extensions, Postgres Package Manager | Scaling Postgres 262

In this episode of Scaling Postgres, we discuss the pg_failover_slots extension, how PG16 allows logical decoding on standbys, what are trusted language extensions and how a package manager has been built for them.

Content Discussed

• PG Failover Slots (pg_failover_slots)
• EnterpriseDB / pg_failover_slots
• Postgres 16 highlight: Logical decoding on standby
• Trusted Language Extensions for Postgres
• dbdev: PostgreSQL Package Manager
• PostgreSQL and SQL:2023
• Writing Data from Postgres to MongoDB
• Who Contributed to PostgreSQL Development in 2022?
• Efficiently Delete Old Rows with Partitions
• Can there be too many partitions?
• Waiting for Postgres 16: Buffer cache hit ratio and I/O times in pg_stat_io
• EXPLAIN (GENERIC_PLAN): New in PostgreSQL 16
• Underscores in numeric constants in PostgreSQL 16
• PostgreSQL for the SQL Server DBA: The First Four Settings to Check
• How To Set Up pgTAP for Writing PostgreSQL Database Unit Tests
• Postgres - Fun with LWLocks
• Waiting for PostgreSQL 16 – Add array_sample() and array_shuffle() functions.
• Accuracy of Geometry data in PostGIS
• Using Encryption-at-Rest for PostgreSQL in Kubernetes
• Read-only considerations
• David Christensen
• Leaving the Cloud With Chris & Creston | Rubber Duck Dev Show 81

YouTube Video