XactSync
Aurora/AWS wait. In this wait event, a session is issuing a COMMIT or ROLLBACK, requiring the current transaction’s changes to be persisted.
Detailed Description
This wait is not found in PostgreSQL documentation as it is an Aurora/AWS specific wait. In this wait event, a session is issuing a COMMIT or ROLLBACK, requiring the current transaction’s changes to be persisted.
How to reduce this wait
This wait most often arises when there is a very high rate of commit activity on the system. You can sometimes alleviate this wait by modifying applications to commit transactions in batches. You might see this wait at the same time as CPU waits in a case where the DB load exceeds the number of virtual CPUs (vCPUs) for the DB instance. In this case, the storage persistence might be competing for CPU with CPU-intensive database workloads. To alleviate this scenario, you can try reducing those workloads, or scaling up to a DB instance with more vCPUs.
Additional Links
Amazon Aurora PostgreSQL events
AWS Aurora IO:XactSync is not a PostgreSQL wait event
Search online
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.