Heavy Reader or Writer? | Scaling Postgres 389

To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/389-heavy-reader-or-writer/ In this episode of Scaling Postgres, we discuss ways to optimize reading or writing, the benefits of a descending index, more information about lightweight locks and a backup public service announcement. 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:53 - Is Postgres Read Heavy or Write Heavy? (And Why You Should Care) 04:38 - Benefits of a DESCending index 07:27 - LWLocks 08:21 - Postgres in Kubernetes: the commands every DBA should know 09:00 - Say Hello to OIDC in PostgreSQL 18! 09:47 - Hybrid Search in PostgreSQL: The Missing Manual 11:13 - Waiting for PostgreSQL 19 – Support COPY TO for partitioned tables. 11:31 - Introducing Generalized Consensus: An Alternate Approach to Distributed Durability 12:20 - Hacking Workshop for November 2025 12::40 - Consulting Corner 14:02 - Outro #postgres #postgresql