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

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

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