activitypub utils: optimize block and follow activity lookup
multi-field @>
comparison is very expensive, so only use @>
for the field where it matters.
this makes the query take only a few usec to execute verses many msec on a busy instance.
multi-field @>
comparison is very expensive, so only use @>
for the field where it matters.
this makes the query take only a few usec to execute verses many msec on a busy instance.