Scaling Postgres

A podcast by Creston Jamison - Sundays

Sundays

Categories:

163 Episodes

  1. Monitoring Progress, More SQL, Replication Slot Failover, Postgres Contributors | Scaling Postgres 198

    Published: 1/16/2022
  2. Explain Analyze Buffers, Healthier Postgres, 2021 Review, High Availability Aspirations | Scaling Postgres 197

    Published: 1/9/2022
  3. Easy Recursive CTE, Zheap Undo, High Availability, Loading Data | Scaling Postgres 196

    Published: 12/19/2021
  4. Aurora vs. Postgres, Surprising Transactions, Write-Only & Read-Only, Indexing Advice | Scaling Postgres 195

    Published: 12/13/2021
  5. Go Faster, GIN Indexes, Collation Stability, PG14 & Beyond | Scaling Postgres 194

    Published: 12/10/2021
  6. Entity-Attribute-Value Design, JSON Subscripting, mysql-fdw Push-down, New Regex | Scaling Postgres 193

    Published: 11/28/2021
  7. Foreign Key Indexes, Graph Queries, Linux Huge Pages, Text Column Size | Scaling Postgres 192

    Published: 11/23/2021
  8. Man-In-The-Middle, pg_auto_failover, Lesser Known Features, LZ4 Compression | Scaling Postgres 191

    Published: 11/15/2021
  9. Hello Babelfish, Planner Deconstruction, Exist & Not Exist, Fun With SQL | Scaling Postgres 190

    Published: 11/8/2021
  10. Index Downsides, TCP Keep Alive, Development with Postgres, Learning PL/pgSQL | Scaling Postgres 189

    Published: 11/1/2021
  11. Automatic Indexing, Function Pipelines, With Hold Cursors, Query Scans | Scaling Postgres 188

    Published: 10/25/2021
  12. Sharding, Federation, Linux HugePages, Performance Tuning | Scaling Postgres 187

    Published: 10/17/2021
  13. Select For Update, PGx Framework, Cool Additions, Full-Text Search | Scaling Postgres 186

    Published: 10/10/2021
  14. Postgres 14 Released, Using JSON, Not Using Indexes, Sequence Gaps | Scaling Postgres 185

    Published: 10/4/2021
  15. Postgres 14 RC1, Little Things, Index Advisor, Million Inserts | Scaling Postgres 184

    Published: 9/26/2021
  16. Broken Indexes, Trademark Issues, Percentile vs. Average, Logical Improvements | Scaling Postgres 183

    Published: 9/20/2021
  17. Boundless Text, Revoked Permissions, Index Bloat, Hardware Performance | Scaling Postgres 182

    Published: 9/12/2021
  18. Connection Scaling, Cached Sequences, Message Queuing, Harmful Subtransactions | Scaling Postgres 181

    Published: 9/6/2021
  19. Aggregate Filters, Insert-Only & Vacuum, Out-of-sync Sequences, Functional Indexes | Scaling Postgres 180

    Published: 8/29/2021
  20. Foreign Data Wrapper, Timescale Compression, Fuzzy Search, Query Execution | Scaling Postgres 179

    Published: 8/23/2021

8 / 9

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.