When Select Writes! | Scaling Postgres 333

To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/333-when-select-writes/ In this episode of Scaling Postgres, we discuss when select can write, Postgres RC1 is released, Tetris in SQL and copy, swap, drop. Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/ Timestamps: 00:00 - Intro 00:44 - Why "SELECT * FROM table" is NOT a read 02:58 - PostgreSQL 17 RC1 Released! 03:32 - Tetris-SQL 04:01 - Shrinking Big PostgreSQL tables: Copy-Swap-Drop 06:36 - Skip scan 08:48 - We need to talk about ENUMs 10:27 - CNPG Recipe 13 - Configuring PostgreSQL Synchronous Replication 10:33 - PostgreSQL Snapshots and Backups with pgBackRest in Kubernetes 11:17 - PITR and Streaming Replication environments 12:29 - pg_auto_dw: a Postgres extension to build well-formed data warehouses with AI 13:13 - Outro #postgres #postgresql