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

Christophe Pettus explains that long transactions holding row locks on thousands of parent rows can cause multixact cache misses and reduce insert throughput. The discussion covers PostgreSQL's `multixact_member_buffers` and `multixact_offset_buffers` settings.

Coverage 1 publisher

  1. Planet PostgreSQL

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

Articles stay on their publishers’ sites; each link opens the original.