Podbean logo
  • Discover
  • Podcast Features

    Your all-in-one podcasting solution.
    Blog to Podcast

    Turn your blog into an engaging podcast.
  • Livestream

    High-performing audio live, without limits.
    Podcast Studio

    Easy-to-use audio recorder app.
  • Podbean AI

    AI-Enhanced Audio Quality and Content Generation.
    Podcast App

    The best podcast player & podcast app.
  • Ads Marketplace

    Join Ads Marketplace to earn money
    through sponsorship on your podcast.
    PodAds

    Manage your ads with dynamic ad insertion capability.
  • Apple Podcasts Subscriptions Integration

    Effortlessly publish and manage exclusive episodes for your
    Apple Podcasts subscribers directly from Podbean.

  • Live Streaming

    Receive livestream rewards from your audience and earn
    recurring income from your Fan Club membership.

  • All Arts Business Comedy Education
  • Fiction Government Health & Fitness History Kids & Family
  • Leisure Music News Religion & Spirituality Science
  • Society & Culture Sports Technology True Crime TV & Film
  • Live
  • How to Start a Podcast
  • How to Start a Live Podcast
  • How to Monetize a podcast
  • How to Promote Your Podcast
  • How to Use Group Recording
  • Log in
  • Start your podcast for free
  • Podcasting
    • Podcast Features
    • Livestream
    • Podbean AI
    • Blog to Podcast
    • Podcast Studio
    • Podcast App
  • Monetization
    • Ads Marketplace
    • Apple Podcasts Subscriptions Integration
    • Live Streaming
    • PodAds
  • Advertisers
  • Enterprise
  • Pricing
  • Discover
    • Log in
    Sign up free
Scaling Postgres

Scaling Postgres

Technology

Scalability Limits From SLRU & Lock Manager | Scaling Postgres 306

Scalability Limits From SLRU & Lock Manager | Scaling Postgres 306

2024-03-10
Download Right click and do "save link as"

In this episode of Scaling Postgres, we discuss one configuration change that resulted in an 11,000 times faster query, why Postgres is not using your index, backported PG improvements and parallelism with TOAST.

To get the show notes as well as get notified of new episodes, visit:

https://www.scalingpostgres.com/episodes/306-scalability-limits-from-slru-lock-manager/

view more

More Episodes

pg_failover_slots, Standby Logical Decoding, Trusted Language Extensions, Postgres Package Manager | Scaling Postgres 262
2023-04-23
Easy Foreign Data Wrappers, JSONB Cheatsheet, Updating Cost Limit, Parallel Aggregate | Scaling Postgres 261
2023-04-17
PL/Rust, Row Locks, Postgres Errors, SQL 2023 | Scaling Postgres 260
2023-04-09
Recovery Time, Lost Data, Production Ready, PG16 Highlights | Scaling Postgres 259
2023-04-02
Logical Replication, Database Antipatterns, max_wal_size Setting, Delete vs. Truncate | Scaling Postgres 258
2023-03-27
Adopting PgCat, Time Bins, work_mem Settings, Bad Constraints | Scaling Postgres 257
2023-03-19
11TB WAL, pgec Writes, Patroni 3 & Citus, PostgREST | Scaling Postgres 256
2023-03-12
Integer Overflow, User-Friendly Permissions, Dump & Logical Replication, Worker Config | Scaling Postgres 255
2023-03-05
PG Edge Cache, Postgres & OpenAI, citext to Collations, Compression Options | Scaling Postgres 254
2023-02-26
Unlogged Tables, pg_stat_io, Type Constraints, Text Types | Scaling Postgres 253
2023-02-19
Postgres Releases, Performance Secrets, Don't Do This, Filter vs. Case | Scaling Postgres 252
2023-02-12
Filter Clause, Hypothetical Index, Non-Relational Data, Using TOAST | Scaling Postgres 251
2023-02-05
Performance Issue, Survive Without Superuser, Reserved Connections, Partition Management | Scaling Postgres 250
2023-01-30
Locking Tables, Foreign Key Issue, Slow Decimals, Memoize & Joins | Scaling Postgres 249
2023-01-23
Pagination Solutions, Return Modifications, Insert Deletions, How To JSON | Scaling Postgres 248
2023-01-15
Generate Test Data, Faster Archiving, Date Statistics, Useless Indexes | Scaling Postgres 247
2023-01-11
Columnar Tables, Advent of Code, PG 16 Features, Commit Times | Scaling Postgres 246
2022-12-18
ENUMs vs Check Constraints, Faceting With Roaring Bitmaps, Better Scaling, In DB Business Logic | Scaling Postgres 245
2022-12-12
Index Merge vs Composite, Transparent Column Encryption, Trusted Language Extensions | Scaling Postgres 244
2022-12-04
IN vs ANY, Ghost Conditions, Percentage Calculations, Variadic Unnest | Scaling Postgres 243
2022-11-27
  • ←
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • →
012345678910111213141516171819

Get this podcast on your
phone, FREE

Download Podbean app on App Store Download Podbean app on Google Play

Create your
podcast in
minutes

  • Full-featured podcast site
  • Unlimited storage and bandwidth
  • Comprehensive podcast stats
  • Distribute to Apple Podcasts, Spotify, and more
  • Make money with your podcast
Get started

It is Free

  • Podcast Services

    • Podcast Features
    • Pricing
    • Enterprise Solution
    • Private Podcast
    • The Podcast App
    • Live Stream
    • Audio Recorder
    • Remote Recording
    • Podbean AI
  •  
    • Create a Podcast
    • Video Podcast
    • Start Podcasting
    • Start Radio Talk Show
    • Education Podcast
    • Church Podcast
    • Nonprofit Podcast
    • Get Sermons Online
    • Free Audiobooks

  • MONETIZATION & MORE

    • Podcast Advertising
    • Dynamic Ads Insertion
    • Apple Podcasts Subscriptions
    • Switch to Podbean
    • YouTube to Podcast
    • Blog to Podcast
    • Submit Your Podcast
    • Podbean Plugins
    • Developers

  • KNOWLEDGE BASE

    • How to Start a Podcast
    • How to Start a Live Podcast
    • How to Monetize a Podcast
    • How to Promote Your Podcast
    • Mobile Podcast Recording Guide
    • How to Use Group Recording
    • Podcast Advertising 101

  • Support

    • Support Center
    • What’s New
    • Free Webinars
    • Podcast Events
    • Podbean Academy
    • Podcasting Smarter
    • Badges
    • Resources

  • Podbean

    • About Us
    • Podbean Blog
    • Careers
    • Press and Media
    • Green Initiative
    • Affiliate Program
    • Contact Us
  • Privacy Policy
  • Cookie Policy
  • Terms of Use
  • Consent Preferences
  • Copyright © 2015-2024 Podbean.com