Scaling Postgres

In this episode of Scaling Postgres, we see examples of using WAIT FOR in PG 19 for handling read after write, local NVME vs block store, new system views and the ambiguity of NULL.

To get the show notes as well as get notified of new episodes, visit: 
https://www.scalingpostgres.com/episodes/433-read-after-write/

Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

In this episode of Scaling Postgres, we discuss getting 23 times faster inserts with UUIDv7, the benefits and downsides of UUIDs, how to optimize queries without table changes and using WAIT FOR to read your writes.

To get the show notes as well as get notified of new episodes, visit: 
https://www.scalingpostgres.com/episodes/432-23-times-faster-inserts-with-uuidv7/

Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

In this episode of Scaling Postgres, we cover postgres.fm's interview of pgrust co-creator Michael Malis, pgDog vs RDS Proxy, Postgres on Kubernetes in 10 minutes and evolution to Postgres 19.

To get the show notes as well as get notified of new episodes, visit: 
https://www.scalingpostgres.com/episodes/431-pgrust-co-creator-postgresfm-interview/

Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

In this episode of Scaling Postgres, we discuss new releases fixing 28 security vulnerabilities, more MVCC, BYOK encryption and should Postgres include pgbouncer.

To get the show notes as well as get notified of new episodes, visit: 
https://www.scalingpostgres.com/episodes/430-28-security-vulnerabilities/

Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

In this episode of Scaling Postgres, we discuss pgrust running analytical queries 300 times faster than Postgres, how to speed up distinct count, Xata podcast and massively parallel backups.

To get the show notes as well as get notified of new episodes, visit: 
https://www.scalingpostgres.com/episodes/429-300-times-faster-analytics-with-pgrust/

Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/