Missed Team ’24? Catch up on announcements here.

×
Create
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Products
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Events
Community resources

WiKi (Confluence) database partitioning for SQL Server

Rakesh Sharma
Rakesh Sharma
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
Get involved
December 8, 2016

Our WiKi (Confluence) database which is running on SQL Server grown to around 600 GB, now there is one table attachmentdata that itself of size 520 GB, are there any guidelines to partitioning this table?

Answer
Watch
Like Be the first to like this
242 views

1 answer

0 votes
Nic Brough -Adaptavist-
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Become a leader
December 9, 2016

Confluence doesn't care how you partition the table at the back end, as long as it looks like a single table to Confluence.

I'm not sure I would worry about it too much though - database storage of attachments has been deprecated and removed from later versions of Confluence.  Although an upgrade will allow you to continue with internal storage for now, later versions won't support it at all, so you might want to consider moving to file based storage instead of database.

Reply

Suggest an answer

Log in or Sign up to answer
Confluence
Confluence
TAGS
AUG Leaders

Atlassian Community Events

    See all events