How does the number of partitions affect performance?

Question

question

hsun asked Nov 8, '21 Erick Ramirez edited Nov 8, '21

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

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

DataStax Enterprise is powered by the best distribution of Apache Cassandra ™

Apache, Apache Cassandra, Cassandra, Apache Tomcat, Tomcat, Apache Lucene, Lucene, Apache Solr, Apache Hadoop, Hadoop, Apache Spark, Spark, Apache TinkerPop, TinkerPop, Apache Kafka and Kafka are either registered trademarks or trademarks of the Apache Software Foundation or its subsidiaries in Canada, the United States and/or other countries.

Privacy Policy Terms of Use

Answer 1 · 2021-11-08T05:19:27Z

Erick Ramirez answered Nov 8, '21 Erick Ramirez edited Nov 8, '21

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

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

question