Christophe Pettus: All Your GUCs in a Row: multixact_member_buffers and multixact_offset_buffers

T2Covered by 1 source · first reported by Planet PostgreSQL at 05 Oct, 01:00 UTC

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..)

cloud

Sources

• T2Christophe Pettus: All Your GUCs in a Row: multixact_member_buffers and multixact_offset_buffersPlanet PostgreSQL05 Oct, 01:00