Scaling Postgres

By Creston JamisonTechnology

Scaling Postgres episodes

May 24 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.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/418-multigres-architecture/
Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/
17 min
May 17 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.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/417-eleven-security-issues/
Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/
20 min
May 10 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.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/416-zero-bloat-postgres-queue/
Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/
16 min
May 03 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.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/415-pgbackrest-is-dead/
Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/
17 min
April 26 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.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/414-repack-concurrently/
Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/
20 min
April 19 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.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/413-shard-with-one-command/
Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/
20 min
April 12 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.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/412-half-as-fast-on-linux-7/
Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/
16 min
April 05 Absorbing Load | Scaling Postgres 411
In this episode of Scaling Postgres, we discuss techniques to absorb excessive query load, BM25 text search via pg_textsearch, good & bad CTEs and plan_cache_mode.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/411-absorbing-load/
Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/
20 min
March 29 Postgres Traffic Cop! | Scaling Postgres 410
In this episode of Scaling Postgres, we discuss a proprietary way of controlling Postgres query traffic, preserving statistics during upgrades, a DB schema migration survey and a new repack command.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/410-postgres-traffic-cop/
Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/
13 min
March 22 Iceberg Causes Postgres Acquisitions? | Scaling Postgres 409
In this episode of Scaling Postgres, we discuss how Apache Iceberg may have lead to Postgres company acquisitions, presentations on CloudNativePG & query tuning, setting up Patroni and utilizing PgBouncer.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/409-iceberg-causes-postgres-acquisitions/
Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/
15 min

About Scaling Postgres

From the publisher's feed

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 developers…