How to reduce the size of Synchrony tables
In Confluence 6.0 to 6.15, Synchrony tables are append-only. As the tables increase in size they may be come too large for some databases.
Note: In Confluence 7.0 and later, two scheduled jobs are available to evict Synchrony data on a regular basis. See How to remove Synchrony data for more information.
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.