What is Nostr?
Yukkuri /
npub1j05…w8rl
2024-01-04 09:49:34
in reply to nevent1q…4zt2

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.
Author Public Key
npub1j05dh9hemkteevv6env2ssv6zrlhj9s904zzknsmylqm2p03w4qsxlw8rl