Huge Increase In Confluence Content Count After Upgrading To Confluence 4.3.3 and Above
Before upgrading Confluence, you have the following stats under Confluence Usage in
Confluence Admin >> System Information:
Total Spaces 61 Global Spaces 34 Personal Spaces 27 Content (All Versions) 18180 Content (Current Versions) 3819 Local Users 63525 Local Groups 167 Search Index Size 15323
After the upgrade, the stats jumped to this:
Total Spaces 61 Global Spaces 34 Personal Spaces 27 Content (All Versions) 85089 Content (Current Versions) 67940 Local Users 63525 Local Groups 167 Search Index Size 138897
Notice the increase in Content (All Versions), and Content (Current Versions). The increase in Search Index Size is expected, due to the increase in content count
The increase in Content count is caused by the fix for this bug:
CONF-11467Getting issue details...
, which will create content of type
USERINFO, for all users, regardless of whether they have logged in to Confluence before or not. If the user does not have a row based on this query before:
SELECT * FROM CONTENT WHERE CONTENTTYPE = 'USERINFO' AND USERNAME = '<username>';
Then an entry will be created for them automatically during the upgrade.