NVME Wins? | Scaling Postgres 388

To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/388-nvme-wins/ In this episode of Scaling Postgres, we discuss PG17 and PG18 benchmarks across storage types, more about Postgres locks, sanitizing SQL and can a faster software & hardware environment cause performance problems? 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:54 - Benchmarking Postgres 17 vs 18 05:48 - #PostgresMarathon 2-006: Mysterious max_locks_per_transaction 06:54 - #PostgresMarathon 2-007: Should we worry about pg_blocking_pids()'s observer effect? 08:07 - #PostgresMarathon 2-008: LWLock:LockManager and prepared statements 09:42 - Sanitized SQL 10:23 - Prairie Postgres Birthday Meetup 10:56 - What's Our Vector, Victor? Building AI Apps with Postgres 11:48 - PostGIS Performance: Indexing and EXPLAIN 12:44 - Keep Calm - TDE for PostgreSQL 18 Is on Its Way! 13:13 - The Fundamental Interconnectedness of All Things with Boriss Mejías 13:24 - Consulting Corner 16:07 - Outro #postgres #postgresql