When the number of subtransactions exceeds 64 and a subxid overflow occurs, other transactions must frequently access the pg_subtrans SLRU cache during MVCC visibility checks, leading to intensified lock contention, increased disk I/O, and reduced throughput.