Ruby Tree Software

Scaling Postgres 428 is released! In this episode, 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: https://www.scalingpostgres.com/episodes/428-postgres-mvcc-is-bad/

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.

Scaling Postgres 427 is released! In this episode, 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: https://www.scalingpostgres.com/episodes/427-migrating-to-pg_hardstorage/

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.

Scaling Postgres 426 is released! In this episode, 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: https://www.scalingpostgres.com/episodes/426-pgrust-faster-than-postgres/

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.

Scaling Postgres 425 is released! In this episode, 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: https://www.scalingpostgres.com/episodes/425-novel-partition-exclusion/

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.

Scaling Postgres 424 is released! In this episode, 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: https://www.scalingpostgres.com/episodes/424-too-many-table-danger/

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.

Scaling Postgres 423 is released! In this episode, we discuss a new backup tool called pg_hardstorage by Cybertech, bottomless storage & ColdFront, monitoring checkpoints and tracking statistics: https://www.scalingpostgres.com/episodes/423-new-backup-tool/

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.

Scaling Postgres 422 is released! In this episode, 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: https://www.scalingpostgres.com/episodes/422-scaling-out-to-226k-tps/

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.

Scaling Postgres 421 is released! In this episode, 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: https://www.scalingpostgres.com/episodes/421-scale-out-funding/

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.

Scaling Postgres 420 is released! In this episode, 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: https://www.scalingpostgres.com/episodes/420-postgres-19-beta-1-released/

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.

Scaling Postgres 419 is released! In this episode, we discuss the dynamic duo of foreign tables and materialized views, the dangers of long-running transactions and job queues and why we cannot have transparent data encryption: https://www.scalingpostgres.com/episodes/419-dynamic-duo/

The Dynamic Duo? | Scaling Postgres 419 In this episode of Scaling Postgres, we discuss the dynamic duo of foreign tables and materialized views, the dangers of long-running transactions and job queues and why we cannot have transparent data encryption.