Collection storage limit in mongodb community edition

[anusha_a]

what is the collection storage limit in mongo db community edition. How many documents can a single collection have?

[steevej (Steeve Juneau)]

According to https://docs.mongodb.com/manual/reference/limits/ and in particular https://docs.mongodb.com/manual/reference/limits/#mongodb-limit-Maximum-Number-of-Documents-in-a-Capped-Collection there is no limit.

[Stennie_X (Stennie)]

Hi @anusha_a,

For related discussion, please see Database and collection limitations - #2 by Stennie.

As I noted there:

@Stennie_X

The theoretical limits for maximum database and collection size are much higher than the practical limits imposed by filesystem, O/S, and system resources relative to workload. You can add server resources and tune for vertical scaling, but when your workload exceeds the resources of a single server or replica set you can also scale horizontally (partitioning data across multiple servers) using sharding .

Practical scaling involves more considerations than the size of data and is highly dependent on your workload, deployment topology, and resources. For example: the amount of data you need to actively work with relative to your total data stored, the volume of read/write operations, and expectations around performance metrics/SLA are all factors.

Regards,
Stennie