3 ms·
I wish Postgres would just allow you look up records by the random component of the field, what are the chances of collisions with 80 bits of randomness? My gue
by andy_ppp 1y ago
I wish Postgres would just allow you look up records by the random component of the field, what are the chances of collisions with 80 bits of randomness? My guess is it’s still enough.
- jagged-chisel 1y agoYou can certainly create that index.
- andy_ppp 1y agoYes, just obviously if it’s automated and part of Postgres people will use it without having to think too much and it removes one of the objections to what I think for most large systems is a sensible way to go rather than controversial because security.
- mamcx 1y agoWhat could be better is to allow to create a type with custom display, in/out and internally set the native type IN SQL (this require to do it in c)