When our users ask this question, I tend to answer "keep it above a
billion". More partitions is better.
I'm not aware of any actual limits on partition count. Practically it's
almost always limited by the disk space in a server.
Tom van der Woerdt
Site Reliability Engineer
Vijzelstraat 66-80 Amsterdam 1017HL Netherlands
[image: Booking.com] <http://www.booking.com/>
The world's #1 accommodation site
43 languages, 198+ offices worldwide, 120,000+ global destinations,
1,550,000+ room nights booked every day
No booking fees, best price always guaranteed
Subsidiary of Booking Holdings Inc. (NASDAQ: BKNG)
On Wed, Mar 7, 2018 at 12:06 PM, Javier Pareja <pareja.jav...@gmail.com>
> Hello all,
> I have been trying to find an answer to the following but I have had no
> luck so far:
> Is there any limit to the number of partitions that a table can have?
> Let's say a table has a partition key an no clustering key, is there a
> recommended limit on the number of values that this partition key can have?
> Is it recommended to have a clustering key to reduce this number by storing
> several rows in each partition instead of one row per partition.
> F Javier Pareja