Scaling Postgres

By Creston JamisonTechnology

Scaling Postgres episodes

August 02 Postgres MVCC Is Bad? | Scaling Postgres 428
In this episode of Scaling Postgres, we discuss how bad Postgres MVCC is, a startup's survival guide for Postgres, an examination of DBOS, and different ways of performing hybrid searches.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/428-postgres-mvcc-is-bad/
Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/
18 min
July 26 Migrating to pg_hardstorage | Scaling Postgres 427
In this episode of Scaling Postgres, we discuss migrating to pg_hardstorage for Postgres backup, PG 19 Beta 2 is released, collecting log stats with pg_stat_log and PG 19 checkpoint additions.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/427-migrating-to-pg_hardstorage/
Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/
9 min
July 19 pgrust Faster Than Postgres? | Scaling Postgres 426
In this episode of Scaling Postgres, we discuss the progress of the Rust rewrite of Postgres called pgrust, more about the backup tool pg_hardstorage, beware listen / notify and how to fix bad SQL.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/426-pgrust-faster-than-postgres/
Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/
16 min
July 12 Novel Partition Exclusion | Scaling Postgres 425
In this episode of Scaling Postgres, we discuss excluding partitions without using a partition key, a pgBackRest interview, Postgres backup without an incremental chain and a replication deadlock bug in Postgres 14-16.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/425-novel-partition-exclusion/
Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/
18 min
July 05 Too Many Table Danger | Scaling Postgres 424
In this episode of Scaling Postgres, we discuss the dangers of too many tables, don't worry about extending checkpoint_timeout, a disaster recovery process, and non-repeatable sums with floating point numbers.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/424-too-many-table-danger/
Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/
16 min
June 28 New Backup Tool | Scaling Postgres 423
In this episode of Scaling Postgres, we discuss a new backup tool called pg_hardstorage by Cybertech, bottomless storage & ColdFront, monitoring checkpoints and tracking statistics.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/423-new-backup-tool/
Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/
15 min
June 21 Scaling Out To 226K TPS | Scaling Postgres 422
In this episode of Scaling Postgres, we discuss scaling out application writes to achieve 226K TPS, try to avoid delete, disaster recovery is a process and avoid NULL in your NOT IN.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/422-scaling-out-to-226k-tps/
Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/
14 min
June 14 Scale Out Funding | Scaling Postgres 421
In this episode of Scaling Postgres, we discuss scale out Postgres projects getting more funding, getting started with Postgres 19 Beta 1 along with its top features and how to review a Postgres patch.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/421-scale-out-funding/
Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/
10 min
June 07 Postgres 19 Beta 1 Released | Scaling Postgres 420
In this episode of Scaling Postgres, we discuss the release of Postgres 19 Beta 1, optimizing autovacuum, the release of Multigres 0.1 Alpha 1, and handling graph queries in Postgres.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/420-postgres-19-beta-1-released/
Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/
19 min
May 31 The Dynamic Duo? | Scaling Postgres 419
In this episode of Scaling Postgres, we go over the architecture of Multigres (Vitess for Postgres), pgBackRest's status, pg_flight_recorder and general SQL optimizations.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/419-dynamic-duo/
Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/
16 min

About Scaling Postgres

From the publisher's feed

Learn how to get the best performance and scale your PostgreSQL database with our weekly shows. Receive the best content curated from around the web. We have a special focus on content for developers…