Event JSON
{
"id": "1bf2c6dd9de58fc1ec143888d3e9ccd8c5a631d83816093c00c9ba4e8105c89e",
"pubkey": "584b9282fbc3d56bde321066766c0ebca3c5508e8d1596a8c7f0a15ca830571c",
"created_at": 1691405721,
"kind": 1,
"tags": [
[
"p",
"633160b9742d8843955766f6ba10a8b86621e4299047584f4a862e76e68a467b",
"wss://relay.mostr.pub"
],
[
"p",
"9980039c0ba514741232c219d86e74b41fb8150ef2cb3b87929f50539ff6a23d",
"wss://relay.mostr.pub"
],
[
"e",
"0152b8e433b20bba5f06c277cb2d6a223ca5bf25535d8d3d8b882e15c67f8da7",
"wss://relay.mostr.pub",
"reply"
],
[
"proxy",
"https://emacs.ch/users/louis/statuses/110847965372094965",
"activitypub"
]
],
"content": "nostr:npub1vvckpwt59kyy892hvmmt5y9ghpnzrepfjpr4sn62sch8de52geas2delhe Have you tried to use the Hash index option of PG for the same effect?\n\nCREATE INDEX name ON table USING HASH (column);",
"sig": "b4ca927d00bb17d9f8adb8e10c07ca4b9b4faec67a19328dc584064b3185f88c1f008573dac5c37e819f61d67c0d3dd4b6e8765dcb2bf2916be3c62ec5d43ebe"
}