Scaling Postgres

In this episode of Scaling Postgres, we discuss Citus 10 open source, time series performance in native Postgres, using subscripting for updates and new target_session_attrs. To get the show notes as well as get notified of new episodes, visit:  https://www.scalingpostgres.com/episodes/155-citus-open-source-time-series-performance-subscripting-updates-target_session_attrs/

In this episode of Scaling Postgres, we discuss the PGMiner botnet attack, how collation changes can cause index corruption, managing your postgresql.conf and implementing custom data types. To get the show notes as well as get notified of new episodes, visit:  https://www.scalingpostgres.com/episodes/145-pgminer-botnet-attack-collation-index-corruption-postgresqlconf-custom-data-types/

In this episode of Scaling Postgres, we discuss various reversions and the uncertain release date of Postgres 19, pgSafe a new backup solution written in Go, inserting state transitions and an operator that supports logical replicas. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/434-postgres-19-reversions/ 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 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/