The dangers of Postgres subtransactions

A single transaction that accumulates numerous subtransaction IDs can significantly reduce throughput across an entire PostgreSQL cluster. It can also stop a new read replica from accepting queries, even as the replica continues to replay WAL. If you add read replicas on demand during a load spike, a replica that cannot open for reads provides no extra capacity.