Scaling Postgres Episode 237 Postgres 15 Released, File Systems, Connection Pooling, Secure Connections

In this episode of Scaling Postgres, we discuss the release of Postgres 15, the performance of different file systems with Postgres, options for connection pooling and how to secure your connections.

Content Discussed

• PostgreSQL 15 Released!
• Be Ready! Public schema changes in Postgres 15
• A Look at Postgres 15: MERGE Command with Examples
• Postgres vs. File Systems: A Performance Comparison
• pgbouncer: Types of PostgreSQL connection pooling
• Don’t make databases available on the public internet
• VPC Peering: From Zero to Hero
• PGSQL Phriday #001 Wrap-up and review!
• Six findings we rely on when managing PostgreSQL indexes
• 5mins of Postgres E39: Postgres 15 release, and 6 tips for managing indexes
• Don’t Forget to Tune Stats Collector for PostgreSQL 14 and Older
• PostgreSQL system catalogs schema diagrams
• Partitioning in Postgres, 2022 edition
• Global Index, a different approach
• 5 Years of Postgres on Kubernetes
• Run PostgreSQL in Kubernetes: Solutions, Pros and Cons
• Postgres Full Text Search vs the rest
• How to Set Up Streaming Replication to Keep Your PostgreSQL Database Performant and Up-to-Date
• PostgreSQL 15
• Christoph Berg
• Rubber Duck Dev Show Episode 61 | Live Streaming Tools & Toys With Aaron Francis

YouTube Video