Comment by Existenceblinks
9 months ago
Looks neat, the first thing I search for in the docs is:
Unique indexes Not currently supported. Requires query rewriting and separate execution engine to validate uniqueness across all shards.
But still looks promising.
Small consolation prize is we can generate unique primary keys: https://docs.pgdog.dev/features/sharding/primary-keys/.
I would like to implement cross-shard unique indexes, but they are expensive to check for every query. Open to ideas!
Aren't UUIDs the a priori collision-free index of choice ?
The problem is which version? Also does the cluster index need to be embedded? Or shard index? Or whatever you are using to track the storage of the record? Should we care?
1 reply →