# Limitations of tiny partitions

**URL:** <https://forum.scylladb.com/t/limitations-of-tiny-partitions/3103>\
**Category:** ScyllaDB\
**Tags:** data-model, sizing, materialized-views, secondary-index, hot-partition\
**Created:** [October 26, 2024, 2:12am UTC](https://forum.scylladb.com/t/limitations-of-tiny-partitions/3103 "2024-10-26T02:12:02Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![sandeepm](https://avatars.discourse-cdn.com/v4/letter/s/cc9497/32.png) [@sandeepm](https://forum.scylladb.com/u/sandeepm)\
**Post date:** [October 26, 2024, 2:12am UTC](https://forum.scylladb.com/t/limitations-of-tiny-partitions/3103/1 "2024-10-26T02:12:02Z")

</div>

I am having around 150 million rows in a table. Each row is a partition which means 150 million partitions. Size of each partition is 24kb.

I know that small partitions work perfectly for even distribution of data without hotspots. But, having partitions as small as 24kb can be a problem in managing them in cache (c++ objects limitations) or using mv’s/secondary index for this table in scylla.

Is this true? Is this improved in latest version of scylla?

---

<div class="post-metadata">

**Author:** ![tzach](https://sea2.discourse-cdn.com/flex016/user_avatar/forum.scylladb.com/tzach/32/172_2.png) [@tzach](https://forum.scylladb.com/u/tzach)\
**Post date:** [October 27, 2024, 6:58am UTC](https://forum.scylladb.com/t/limitations-of-tiny-partitions/3103/2 "2024-10-27T06:58:17Z")

</div>

No problem. ScyllaDB is designed to support billions of partitions.

---

<div class="post-metadata">

**Author:** ![sandeepm](https://avatars.discourse-cdn.com/v4/letter/s/cc9497/32.png) [@sandeepm](https://forum.scylladb.com/u/sandeepm)\
**Post date:** [October 27, 2024, 7:30am UTC](https://forum.scylladb.com/t/limitations-of-tiny-partitions/3103/3 "2024-10-27T07:30:22Z")

</div>

Thanks for your reply.

Just to cross check, tiny partitions won’t be blocker for

- materialized view’s and secondary indexes during repairs.
- caching tiny partitions in memory

Thanks.

---

<div class="post-metadata">

**Author:** ![felipemendes](https://sea2.discourse-cdn.com/flex016/user_avatar/forum.scylladb.com/felipemendes/32/11_2.png) [@felipemendes](https://forum.scylladb.com/u/felipemendes)\
**Post date:** [October 28, 2024, 2:29pm UTC](https://forum.scylladb.com/t/limitations-of-tiny-partitions/3103/4 "2024-10-28T14:29:09Z")

</div>

You should be fine. Plus, if needed, you can always tune bloom filter, repair intensities, and compaction settings in case you find anything weird later on.