nostr:npub1vvckpwt59kyy892hvmmt5y9ghpnzrepfjpr4sn62sch8de52geas2delhe Have you tried to use the Hash index option of PG for the same effect?

CREATE INDEX name ON table USING HASH (column);