To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/318-postgres-17-beta-1-released/ In this episode of Scaling Postgres, we discuss all the new features in Postgres 17 Beta 1, some features that did not make it, database collations & sorting and causes of slow commits. Want to learn more about Postgres performance? Join my FREE mini-course called the PostgreSQL Performance Starter Kit here: https://www.scalingpostgres.com/courses/postgresql-performance-starter-kit/ Timestamps: 00:00 - Intro 00:19 - PostgreSQL 17 Beta 1 Released! 03:43 - What's (not) in Postgres 17 beta1, and how to test it 05:15 - Default Sort Order in Db2, SQL Server, Oracle & Postgres 17 06:44 - PostgreSQL Performance Starter Kit 07:02 - Why do I have a Sloq Commit in PostgreSQL 09:31 - How We Fused DuckDB into Postgres with Crunchy Bridge for Analytics 10:55 - Top Five PostgreSQL Surprise from Rails Devs 12:59 - Full text Search 14:37 - Carbon Footprint and Query Optimization 15:10 - Custom PostgreSQL extensions with Rust 16:18 - Converting DMS to PostGIS Point Geometry 16:59 - PostgreSQL Data Cleaning vs. Python Data Cleaning 17:26 - Outro #postgres #postgresql