To get the show notes as well as get notified of new episodes, visit: In this episode of Scaling Postgres, we discuss why and how you could move off of AWS RDS, Snowflake acquires Crunchy Data, reducing your SQL queries and a novel way to migrate to partition tables. Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: Timestamps: 01:37 - How to move off RDS 05:38 - Crunchy Data Joins Snowflake 06:21 - Snowflake Acquires Crunchy Data to Bring Enterprise Ready Postgres Offering to the AI Data Cloud 06:32 - Tip: Put your Rails app on a SQL Query diet 07:43 - Bridged Indexes in OrioleDB: architecture, internals & everyday use? 10:11 - Building on open table formats 10:49 - Approximate the p99 of a query with pg_stat_statements 11:36 - Postgres Partitioning Best Practices 12:26 - Yes, Postgres can do session vars - but should you use them? 13:39 - Benchmarking is hard, sometimes ... 14:33 - Ultimate Guide to POSETTE: An Event for Postgres, 2025 edition 14:56 - Consulting Corner 17:42 - Outro #postgres #postgresql