Skip to content
Artwork for Scaling Postgres

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
  • 23 episodes
  • weekly
  • Avg 15 min
  • English
Counted on this page — what you have heard stays on this device, so it is not something the list can be paged by.
  • #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–23 of 23 episodes