Monitoring and forecasting PostgreSQL MultiXact member exhaustion performance cliff
Materials:
- https://aws.amazon.com/blogs/database/multixacts-in-postgresql-usage-side-effects-and-monitoring/
- https://metronome.com/blog/root-cause-analysis-postgresql-multixact-member-exhaustion-incidents-may-2025
- https://postgres.ai/blog/20210831-postgresql-subtransactions-considered-harmful#problem-3-unexpected-use-of-multixact-ids
- https://buttondown.com/nelhage/archive/notes-on-some-postgresql-implementation-details/
- https://www.postgresql.org/message-id/flat/CAH2-WzmLPWJk3gbAxy8dHY%2BA-Juz_6uGwfe6DkE8B5-dTDvLcw%40mail.gmail.com
- https://postgrespro.com/list/thread-id/2388130
- https://github.com/postgres/postgres/blob/REL_13_STABLE/src/backend/access/transam/multixact.c
Edited by Denis Morozov