PostgreSQL's MultiXact machinery — src/backend/access/transam/multixact.c — the multi-transaction ID system that lets a single heap tuple record multiple concurrent lockers (for SELECT ... FOR SHARE and SELECT ... FOR UPDATE blends) plus the multixact-freeze / wraparound path. Loads when the user asks about MultiXactId semantics, xmax interpretation with the HEAPXMAXISMULTI bit, why a tuple can appear to be locked by multiple transactions, tuple-locking modes (FOR SHARE / FOR NO KEY UPDATE / FOR KEY SHARE), the multixact SLRU (pgmultixact/), MultiXact member offsets, or the autovacuummultixactfreezemaxage wraparound path. Skip when the ask is about clog (regular transaction commit status — sibling but different code) or 2PC prepared transactions.
Install with
Claude CodeCodexCursorGitHub CopilotGemini CLI
Supported by the Atlas install prompt. Skill-specific requirements vary.
Skill stats
Skills1CategoryEngineeringStars0
About this skill
PostgreSQL's MultiXact machinery — src/backend/access/transam/multixact.c — the multi-transaction ID system that lets a single heap tuple record multiple concurrent lockers (for SELECT ... FOR SHARE and SELECT ... FOR UPDATE blends) plus the multixact-freeze / wraparound path. Loads when the user asks about MultiXactId semantics, xmax interpretation with the HEAPXMAXISMULTI bit, why a tuple can appear to be locked by multiple transactions, tuple-locking modes (FOR SHARE / FOR NO KEY UPDATE / FOR KEY SHARE), the multixact SLRU (pgmultixact/), MultiXact member offsets, or the autovacuummultixactfreezemaxage wraparound path. Skip when the ask is about clog (regular transaction commit status — sibling but different code) or 2PC prepared transactions.
Quick start
Copy the install prompt. Use the green button above this README.
Send it to your agent. Paste it into your coding agent’s chat and send.
Review the setup. Your agent checks the skill’s instructions, requirements, and installation scope.
PostgreSQL's MultiXact machinery — `src/backend/access/transam/multixact.c` — the multi-transaction ID system that lets a single heap tuple record multiple concurrent lockers (for `SELECT ... FOR SHARE` and `SELECT ... FOR UPDATE` blends) plus the multixact-freeze / wraparound path. Loads when the user asks about MultiXactId semantics, `xmax` interpretation with the `HEAP_XMAX_IS_MULTI` bit, why a tuple can appear to be locked by multiple transactions, tuple-locking modes (`FOR SHARE` / `FOR NO KEY UPDATE` / `FOR KEY SHARE`), the multixact SLRU (`pg_multixact/`), MultiXact member offsets, or the `autovacuum_multixact_freeze_max_age` wraparound path. Skip when the ask is about clog (regular transaction commit status — sibling but different code) or 2PC prepared transactions.
About this listing
Category
Engineering
Reported license
PostgreSQL
Listing language (estimated)
English
Review status
Not individually reviewed
Agent compatibility
Atlas installation supports Claude Code, Codex, and Cursor. Skill-specific dependencies and features are checked during setup.