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

To get the show notes as well as get notified of new episodes, visit:

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.

Want to learn more about Postgres performance?

Timestamps:
00:00 - Intro
00:28 - PostgreSQL 15 Released!
01:34 - Be Ready! Public schema changes in Postgres 15
03:00 - A Look at Postgres 15: MERGE Command with Examples
03:34 - Postgres vs. File Systems: A Performance Comparison
05:56 - pgbouncer: Types of PostgreSQL connection pooling
08:51 - Don’t make databases available on the public internet
10:37 - VPC Peering: From Zero to Hero
11:20 - PGSQL Phriday #001 Wrap-up and review!
11:40 - Six findings we rely on when managing PostgreSQL indexes
11:56 - 5mins of Postgres E39: Postgres 15 release, and 6 tips for managing indexes
12:12 - Don’t Forget to Tune Stats Collector for PostgreSQL 14 and Older
12:59 - Partitioning in Postgres, 2022 edition
14:15 - Global Index, a different approach
14:46 - 5 Years of Postgres on Kubernetes
15:15 - Run PostgreSQL in Kubernetes: Solutions, Pros and Cons
15:58 - Postgres Full Text Search vs the rest
17:23 - How to Set Up Streaming Replication to Keep Your PostgreSQL Database Performant and Up-to-Date
17:41 - PostgreSQL 15
17:54 - Christoph Berg
18:04 - Rubber Duck Dev Show Episode 61 | Live Streaming Tools & Toys With Aaron Francis
18:27 - Outro

#postgres #postgresql