Scaling Postgres 443 is released! In this episode, we discuss new Postgres minor releases that patch 52(!) vulnerabilities, the AI impact on Postgres, pgrust progress, and handling extensions in containers: scalingpostgres.com/episodes… #Postgres #PostgreSQL
51
Scaling Postgres 442 is released! In this episode, we examine how pgrust is designed to be as fast as possible, the advantages of UUIDv7 over UUIDv4, how to setup a multi-master cluster based upon regions and how to get rid of a 4 TB table: scalingpostgres.com/episodes… #Postgres #PostgreSQL
4
129
Scaling Postgres 441 is released! In this episode, we discuss the public beta of Oriole DB, 100,000 times faster queries with GPUs, post pg_restore to-do and a lesson in data integrity: scalingpostgres.com/episodes… #Postgres #PostgreSQL
33
Scaling Postgres 440 is released! In this episode, we discuss how to reach 10 million queries per second efficiently, Postgres performance on GPUs, the next release of pgrust and not trusting ON DELETE CASCADE: scalingpostgres.com/episodes… #Postgres #PostgreSQL
Scaling Postgres 439 is released! In this episode, we review two companies battling one another for text search dominance in Postgres, faster vector search with pg_vectorsearch, pushing Citus scaling with query routers and PostgreSQL 19 RC1 is released: scalingpostgres.com/episodes… #Postgres #PostgreSQL
Scaling Postgres 438 is released! In this episode, we discuss performance improvements in ParadeDB as a result of PlanetScale, an open source BM25 index from PGX Inc., pgbouncer and pgvector patching and direct I/O benefits during backup: scalingpostgres.com/episodes… #Postgres #PostgreSQL
3
127
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: scalingpostgres.com/episodes… #Postgres #PostgreSQL
51
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: scalingpostgres.com/episodes… #Postgres #PostgreSQL
2
96
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: scalingpostgres.com/episodes… #Postgres #PostgreSQL
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: scalingpostgres.com/episodes… #Postgres #PostgreSQL
37
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: scalingpostgres.com/episodes… #Postgres #PostgreSQL
47
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: scalingpostgres.com/episodes… #Postgres #PostgreSQL
3
73
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: scalingpostgres.com/episodes… #Postgres #PostgreSQL
2
81
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: scalingpostgres.com/episodes… #Postgres #PostgreSQL
1
1
167
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: scalingpostgres.com/episodes… #Postgres #PostgreSQL
4
140
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: scalingpostgres.com/episodes… #Postgres #PostgreSQL
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: scalingpostgres.com/episodes… #Postgres #PostgreSQL
2
134
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: scalingpostgres.com/episodes… #Postgres #PostgreSQL
3
173
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: scalingpostgres.com/episodes… #Postgres #PostgreSQL
4
243
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: scalingpostgres.com/episodes… #Postgres #PostgreSQL
95
