Ruby Tree Software

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.

Scaling Postgres 418 is released! In this episode, we discuss the architecture of Multigres (Vitess for Postgres), pgBackRest's status, pg_flight_recorder and general SQL optimizations: http://scalingpostgres.com/episodes/418-multigres-architecture/

Multigres Architecture | Scaling Postgres 418 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.

Scaling Postgres 417 is released! In this episode, we discuss new Postgres releases that patch eleven security issues, a new pgbouncer release patching four security issues, making JSON queryable, and issues with views: https://www.scalingpostgres.com/episodes/417-eleven-security-issues/

11 Security Issues | Scaling Postgres 417 In this episode of Scaling Postgres, we discuss new Postgres releases that patch eleven security issues, a new pgbouncer release patching four security issues, making JSON queryable, and issues with views.

Scaling Postgres 416 is released! In this episode, we discuss a new zero bloat Postgres queue called PgQue, maybe pgBackRest isn't dead, multixact members at 64 bits and using session variables: https://www.scalingpostgres.com/episodes/416-zero-bloat-postgres-queue/

Zero Bloat Postgres Queue | Scaling Postgres 416 In this episode of Scaling Postgres, we discuss a new zero bloat Postgres queue called PgQue, maybe pgBackRest isn't dead, multixact members at 64 bits and using session variables.

Scaling Postgres 415 is released! In this episode, we discuss the notice of obsolescence for pgBackRest, the open source environment in general, queries to monitor autovacuum and pg_wait_tracer: https://www.scalingpostgres.com/episodes/415-pgbackrest-is-dead/

pgBackRest Is Dead? | Scaling Postgres 415 In this episode of Scaling Postgres, we discuss the notice of obsolescence for pgBackRest, the open source environment in general, queries to monitor autovacuum and pg_wait_tracer.

Scaling Postgres 414 is released! In this episode, we discuss repack concurrently coming to PG 19, how to design your schema, all about hints and enforcing constraints across partitions: https://www.scalingpostgres.com/episodes/414-repack-concurrently/

Repack Concurrently | Scaling Postgres 414 In this episode of Scaling Postgres, we discuss repack concurrently coming to PG 19, how to design your schema, all about hints and enforcing constraints across partitions.

Scaling Postgres 413 is released! In this episode, we discuss sharding your database with one command, more information about the Linux 7 Postgres performance regression, Xata going open source, and checkpoints and WAL storms: https://www.scalingpostgres.com/episodes/413-shard-with-one-command/

Shard With One Command | Scaling Postgres 413 In this episode of Scaling Postgres, we discuss sharding your database with one command, more information about the Linux 7 Postgres performance regression, Xata going open source, and checkpoints and WAL storms.

Scaling Postgres 412 is released! In this episode, we discuss we discuss how Postgres may be half as fast on the new Linux 7 kernel, PostgresBench, what is missing in Postgres and WAL to distribute data: https://www.scalingpostgres.com/episodes/412-half-as-fast-on-linux-7/

Half as Fast on Linux 7 | Scaling Postgres 412 In this episode of Scaling Postgres, we discuss how Postgres may be half as fast on the new Linux 7 kernel, PostgresBench, what is missing in Postgres and WAL to distribute data.