Postgres MVCC Is Bad? | Scaling Postgres 428

In this episode of Scaling Postgres, we discuss how bad Postgres MVCC is, a startup's survival guide for Postgres, an examination of DBOS, and different ways of performing hybrid searches.

Content Discussed

• PostgreSQL's MVCC is bad. So is everyone else's.
• The startup's Postgres survival guide
• DBOS
• Hybrid Search Patterns with Postgres and pgvector
• Hybrid Search in PostgreSQL: BM25, Sparse Vectors, and Reciprocal Rank Fusion
• Looking Forward to Postgres 19: Autovacuum Tweaks
• The Hidden Cost of Postgres Constraints at Scale
• Highlights of Fujitsu's contribution in PostgreSQL 19
• Data Lineage in PostgreSQL 19: Finally, an Answer When the CFO Asks "Where Did This Number Come From?"
• What's new in Postgres 19
• SQL Improvements in PostgreSQL 11–18: A Personal Selection
• Postgres backups under the hood
• vip-manager v5 is out: what you need to know
• AI Chat With DBeaver Community Edition
• Why your pioneering Postgres feature should start in a fork
• The Right Way to Give a Third-Party DBA Access to Your PostgreSQL Database
• Why Enterprise Platforms Often Fail Long Before They Break
• TimescaleDB 2.28: Faster Queries, Lighter Operations, and Better Schema Evolution
• Building scalable applications on Amazon Aurora DSQL
• Automated PII redaction for Amazon RDS for PostgreSQL audit logs
• Migrate self-managed PostgreSQL to Amazon RDS using the RDS console

YouTube Video

Podcast Audio