How to reduce the size of Synchrony tables
Synchrony tables are append-only at this time. As the tables increase in size they may be come too large for some databases.
The Synchrony tables can be truncated to resolve the issue.
Please note that turning Collaborative editing OFF and ON again may remove any unsaved drafts. You may refer to this page - How Do Drafts Work on Confluence for detailed information regarding drafts. Please follow the steps below to identify and publish unpublished drafts.
Identify unpublished drafts: How to recover or identify a lost shared draft after disabling collaborative editing in Confluence
- Have the users publish or discard the changes
- Turn off collaborative editing
- Truncate the tables
Don't do this while collaborative editing is on
TRUNCATE TABLE "EVENTS"; TRUNCATE TABLE "SECRETS"; TRUNCATE TABLE "SNAPSHOTS";
- Turn on collaborative editing.