Bringing together the Apache Cassandra experts from the community and DataStax.

Want to learn? Have a question? Want to share your expertise? You are in the right place!

Not sure where to begin? Getting Started

 

question

hsun avatar image
hsun asked Erick Ramirez edited

How does the number of partitions affect performance?

Hi,

We have a table partitioned by primary key. It ended up with 2 billions of partitions. Is this gonna have negative impact on performance for certain operations?

Thanks

performance
10 |1000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

1 Answer

Erick Ramirez avatar image
Erick Ramirez answered Erick Ramirez edited

It doesn't have any bearing on performance.

In theory, Cassandra scales infinitely with -2^63 to 2^63-1 possible partitions so you can virtually have as many as you want. Cheers!

Share
10 |1000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.