Heavy Reader or Writer? | Scaling Postgres 389
Join Over 1,000 Engineers & Get New Episodes Weekly!
In this episode of Scaling Postgres, we discuss ways to optimize reading or writing, the benefits of a descending index, more information about lightweight locks and a backup public service announcement.
Content Discussed
- Is Postgres Read Heavy or Write Heavy? (And Why You Should Care)
- Benefits of a DESCending index
- LWLocks
- Postgres in Kubernetes: the commands every DBA should know
- Say Hello to OIDC in PostgreSQL 18!
- Hybrid Search in PostgreSQL: The Missing Manual
- Waiting for PostgreSQL 19 – Support COPY TO for partitioned tables.
- Introducing Generalized Consensus: An Alternate Approach to Distributed Durability
- Hacking Workshop for November 2025
- PostGIS Performance: pg_stat_statements and Postgres tuning
- Part 2: Postgres incredible journey to the top with developers.
- Scaling Postgres
- Configuring Linux Huge Pages for PostgreSQL
- Revising the Postgres Multi-master Concept
- Understanding the Execution Plan of a Hash Join
- Create and debug PostgreSQL extension using VS Code
- Loading The Titanic Passenger Data Into PostgreSQL With DBeaver Part 2
- Check out my new repo: logs_processing
- PgPedia Week, 2025-10-12
- Contributions for week 41, 2025
- Contributions for week 42, 2025
- PGConf.EU 2025: The Underground Map for Database Nerds
- Postgres for Agents
- How to Train Your Agent to Be a Postgres Expert
- Introducing Agentic Postgres Free Plan: The Fastest Way to Experiment with AI on Postgres
- Handling Time-Variant DAGs with Constraints in Postgres
YouTube Video
Podcast Audio
