Skip to content
Sign in
Artwork for Scaling Postgres
Technology

Scaling Postgres

Creston Jamison

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 since your architecture and usage is the key to getting the most performance out of PostgreSQL.

Play
Open in
  • 25 episodes
  • weekly
  • Avg 15 min
  • English

Episodes 25

NewestOldestLongest
All5Unplayed5In progress0Played0
Counted on this page — what you have heard stays on this device, so it is not something the list can be paged by.
  • #415
    May 3 · 16 min

    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-demystif

  • #414
    April 26 · 19 min

    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/

  • #413
    April 19 · 19 min

    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/c

  • #412
    April 12 · 15 min

    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-demys

  • #411
    April 5 · 19 min

    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/

Showing 21–25 of 25 episodes