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 soluti...
Radio and PodcastLive Radio & PodcastsTechnology
Scaling Postgres
Learn how to get the best performance and scale your PostgreSQL database with our weekly shows. Receive the best content curated from around the web. We have a special focus on content for d...
Episodes
20 of 434 episodesRead 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, ne...
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 opt...
pg_rust Co-Creator postgres.fm Interview | Scaling Postgres 431
In this episode of Scaling Postgres, we cover postgres.fm's interview of pgrust co-creator Michael Malis, pgDog vs RDS Proxy, Postgres on Ku...
28 Security Vulnerabilities | Scaling Postgres 430
In this episode of Scaling Postgres, we discuss new releases fixing 28 security vulnerabilities, more MVCC, BYOK encryption and should Postg...
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 c...
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, a...
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 st...
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_ha...
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...
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 r...
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, monito...
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 i...
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 al...
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...
The Dynamic Duo? | Scaling Postgres 419
In this episode of Scaling Postgres, we go over the architecture of Multigres (Vitess for Postgres), pgBackRest's status, pg_flight_recorder...
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...
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 fo...
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...
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 t...