4 ms·
Same pain as with good old (native) partitioning, right? :) As with partitioning, in my experience something like a common key (identifying data sets), tenant
by mindcrash 2y ago
Same pain as with good old (native) partitioning, right? :)
As with partitioning, in my experience something like a common key (identifying data sets), tenant id and/or partial date (yyyy-mm) work pretty great
- caffeinated_me 2y agoFor a multi-tenant use case, yeah, pretty close to thinking about partitioning. For other use cases, there can be big gains from cross-shard queries that you can't really match with partitioning, but that's super use case dependent and not a guaranteed result.