A free weekly show on how to scale your PostgreSQL relational database.Join over a thousand engineers keeping current on relevant Postgres content.
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.
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.
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.
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.
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.
