3 ms·
> PG seems to have this issue as well but the limit is 2712 bytes. Note that this is only for bytes indexes. Hash is not so limited. Tho at this sort of sizes
by masklinn 4y ago
> PG seems to have this issue as well but the limit is 2712 bytes.
Note that this is only for bytes indexes. Hash is not so limited.
Tho at this sort of sizes it seems unlikely such simple indexes are of much use. I guess the range matching abilities of btrees could be but that seems unlikely, a 2700 bytes path-like datum is a lot.