Yukkuri on Nostr: Eientei has RUM enabled, but RUM's tsvector is applied to objects table, rather ...
(npub1ajw…aj8d) Eientei has RUM enabled, but RUM's tsvector is applied to objects table, rather than activities. Still, if you observe search queries opting for sequential scan instead of using rum index, increasing fts_content sampling rate may help nudge the planner in the right direction, but use explain analyze to verify it's indeed filtering instead of doing bitmap/index scan and beware of increased analyze times, greater accuracy for planner estimates isn't free.
Published at
2024-01-04 09:49:34Event JSON
{
"id": "86c64b5fde3018bdbec5b1e0b46702739121bf1a944949673c5a258eeaf0a485",
"pubkey": "93e8db96f9dd979cb19accd8a8419a10ff7916057d442b4e1b27c1b505f17541",
"created_at": 1704361774,
"kind": 1,
"tags": [
[
"p",
"ec9dae9b3dc5951ac7d6cb7070d9c8bcf3998ed72fe4931906e6c7a5ead51ad8",
"wss://relay.mostr.pub"
],
[
"e",
"74b6989885009cfa884a06a7138aea2644ec69bfe7aba289bf9ad2267b765093",
"wss://relay.mostr.pub",
"reply"
],
[
"proxy",
"https://eientei.org/objects/fad94a20-28de-4756-a42f-6773cc3f1dfd",
"activitypub"
]
],
"content": "nostr:npub1ajw6axeack23437kedc8pkwghneenrkh9ljfxxgxumr6t6k4rtvqecaj8d Eientei has RUM enabled, but RUM's tsvector is applied to objects table, rather than activities. Still, if you observe search queries opting for sequential scan instead of using rum index, increasing fts_content sampling rate may help nudge the planner in the right direction, but use explain analyze to verify it's indeed filtering instead of doing bitmap/index scan and beware of increased analyze times, greater accuracy for planner estimates isn't free.",
"sig": "bbbf23d56b01fb8e5e1c26836f81f2ffd36d79e405ef266e65994d4e31f76d9c4b15832236273f780c7d54c3684079d39a69e53e23d3a4ba8d49384d02b35e02"
}