Subtransactions and performance degradation. Part 1: PGPROC_MAX_CACHED_SUBXIDS
Show how reaching higher numbers of subtransactions can affect performance. Questions:
- is reaching PGPROC_MAX_CACHED_SUBXIDS (default: 64) bad for performance?
- what sessions may be affected? (other sessions in the same logical DB; sessions to other logical DBs; sessions on replicas)
Related:
Edited by Nikolay Samokhvalov