Database
Christophe Pettus: All Your GUCs in a Row: multixact_member_buffers and multixact_offset_buffers
Planet PostgreSQL0 views
When one long transaction holds row locks on thousands of parents, multixact cache misses can tank insert throughput. (I consult on PostgreSQL through PGX Inc..)
Source:https://postgr.es/p/9wZPreviousCornelia Biacsics: Contributions for week 39NextChristophe Pettus: All Your GUCs in a Row: min_wal_size
Related posts
Designing a Reliable Database for an E-Commerce Application
0dev.to

We're Looking for 10 dbt Developers to Test Relationship-Aware JOINs — 12 Months Free
0dev.to Data
The Best Disaster Recovery Solutions for Cross-Geography Replication (2026): Compared by What They Replicate
0dev.to Database

SQL Challenge: Can You Find the Second Purchase of Every Customer Using ROW_NUMBER()?
0dev.to Database

Database Migrations at Scale: How to Change Production Databases Without Breaking Applications
0dev.to Database

The Double-Booked Seat: Fixing a Booking Race Condition in Postgres
0dev.to Database