Ruby Tree Software

Scaling Postgres 437 is released! In this episode, we discuss the reasons for all the PG 19 reversions, why open source wins, the cost of REPACK CONCURRENTLY and hint implementations: https://www.scalingpostgres.com/episodes/437-reason-for-reversions/

The Reason For Reversions | Scaling Postgres 437 In this episode of Scaling Postgres, we discuss the reasons for all the PG 19 reversions, why open source wins, the cost of REPACK CONCURRENTLY and hint implementations.

Scaling Postgres 436 is released! In this episode, we discuss PG19 Beta 4, pgBouncer CVEs, managed provider security and transferring data to Clickhouse using physical replication: https://www.scalingpostgres.com/episodes/436-postgres-19-beta-4-released/

Postgres 19 Beta 4 Released! | Scaling Postgres 436 In this episode of Scaling Postgres, we discuss PG19 Beta 4, pgBouncer CVEs, managed provider security and transferring data to Clickhouse using physical replication.

Scaling Postgres 435 is released! In this episode, we discuss possibly twelve different feature reversions in Postgres 19 and why, the impact of one more index, the cost of a single insert and Neki is released: https://www.scalingpostgres.com/episodes/435-postgres-19-revert-train/

Postgres 19 Revert Train! | Scaling Postgres 435 In this episode of Scaling Postgres, we discuss possibly twelve different feature reversions in Postgres 19 and why, the impact of one more index, the cost of a single insert and Neki is released.

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

Postgres 19 Reversions | Scaling Postgres 434 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.

Scaling Postgres 433 is released! In this episode, 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: https://www.scalingpostgres.com/episodes/433-read-after-write/

Read After Write | Scaling Postgres 433 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.

Scaling Postgres 432 is released! In this episode, 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: https://www.scalingpostgres.com/episodes/432-23-times-faster-inserts-with-uuidv7/

23 Times Faster Inserts With UUIDv7 | Scaling Postgres 432 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.

Scaling Postgres 431 is released! In this episode, we cover postgresfm's interview of pgrust co-creator Michael Malis, pgDog vs RDS Proxy, Postgres on Kubernetes in 10 minutes and evolution to Postgres 19: https://www.scalingpostgres.com/episodes/431-pgrust-co-creator-postgresfm-interview/

Scaling Postgres 430 is released! In this episode, we discuss new releases fixing 28 security vulnerabilities, more MVCC, BYOK encryption and should Postgres include pgbouncer: https://www.scalingpostgres.com/episodes/430-28-security-vulnerabilities/

www.scalingpostgres.com

Scaling Postgres 429 is released! In this episode, we discuss pgrust running analytical queries 300 times faster than Postgres, how to speed up distinct count, Xata podcast and massively parallel backups: https://www.scalingpostgres.com/episodes/429-300-times-faster-analytics-with-pgrust/

300 Times Faster Analytics With pgrust | Scaling Postgres 429 In this episode of Scaling Postgres, we discuss pgrust running analytical queries 300 times faster than Postgres, how to speed up distinct count, Xata podcast and massively parallel backups.

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.