Is it possible to have 2 physical partitions instead of the default 10 in Azure Cosmos DB?
We switched to a partitioned collection to have better performance on aggregate queries. However since we have 2.500 RU/s for the entire collection, this leaves us with 250 RU/s per physical partition (Cosmos DB automatically creates 10 physical partition).
We would like to improve the RU/s per partition, without scaling the RU/s for the whole collection. So having fewer partitions would benefit us.
-Edit-
The azure support changed the default collection size to 20gb with 2 physical partitions for us. In this way we have higher performance per physical partition. Since performance is set on collection level and divided by the amount of physical partitions.
The support also said that it was not possible to alter partition size, so a physical partition in azure kosmos db is fixed to 10gb. When you need more storage there is no other way than setting a higher RU/s for your collection to maintain the same level of performance per partition.