Confluence Database - Size Limits

[Dheeraj Gumudavelli]

Hi,

I would like to know, what is the size limit for a database.

Thanks

[Kishan Sharma]

Hi @Dheeraj Gumudavelli 

Welcome to the Atlassian Community!

In confluence databases, fields or entries are not limited, but be aware that large databases can take longer to load and quickly become very complex. 

Atlassian Confluence Cloud has some storage limits that depend on your subscription plan, and these limits cover everything from attachments to databases and other data within Confluence.

1. Free Plan: 2 GB of total storage.
2. Standard Plan: 250 GB of total storage.
3. Premium and Enterprise Plans: Unlimited file storage.

Hope this helps.

[Dheeraj Gumudavelli]

Hi @Kishan Sharma 

Thank you for your answer. I would like to know if there are any limits on the number of columns in a database. Because I tried to import a csv which had around 100+ columns and 3000+ rows. But I see that it didnt allow me to have those many columns.

[Kishan Sharma]

Hi @Dheeraj Gumudavelli 

I was unable to locate any public documentation regarding these limitations. I created a CSV file containing 150 columns and over 3,000 rows, but the import process into the database became unresponsive and ultimately failed. I recommend submitting a ticket to Atlassian Support to inquire about this issue. Please share the response you receive here for everyone's benefit. :)

[Humashankar VJ]

Hi @Dheeraj Gumudavelli 

Confluence Database Size and Performance Considerations

While Confluence doesn't enforce a strict database size limit, its performance is influenced by factors like database system (PostgreSQL, MySQL, Oracle), server resources, and configuration. To ensure optimal performance, consider the following:

Database Size and Performance

Monitor database growth, as large databases can slow down Confluence, particularly during querying and indexing.

Scale server resources accordingly to maintain performance.

Storage Recommendations

Keep an eye on your Confluence setup when the database exceeds hundreds of gigabytes.

Regular maintenance, archiving old content, and database tuning can manage growth.

Database-Specific Limits

Each database type has its own size limits based on file and table sizes:

PostgreSQL handles terabytes, but performance varies with hardware and indexing.

MySQL default table size limit is 4 GB, but can be increased with engine and storage settings adjustments.

Confluence Content Limits

Individual page sizes and attachment sizes have limits:

Default maximum attachment size is 100 MB (configurable).

To learn more:

Limits in size (Mb) and records for Databases?

Solved: Maximum size of databases

Hope this helps - Happy to help further!!
Thank you very much and have a great one!
Warm regards