I have a DynamoDB GSI with a low cardinality (1) partition key and a sort key. I'm not able to find any information about any limits for this partition key. I already read how it's supposed to behave in case of primary key with a low cardinality as described here, but I'm not sure if the same principles apply for global secondary indexes.
My main concern is: Can I fetch the items properly sorted by the sort key no matter how much the index grows? Or I need to resort to write-sharding as described here?
Any help or a pointer to the documentation describing the behavior will be highly appreciated.