:therian: void :mk-tags_base-doll: :mk-tags_base-kit: (@void)

Lilith Ashley Nyx Arson

@root@possum.city

finally getting around to setting up proper note search for possum.city btw

void

@void@dolls.social

@root which? sharkey had meilisearch or some sql things iirc

Lilith Ashley Nyx Arson

@root@possum.city

@void meilisearch. sql is slow as shit because the notes table has almost 50 million rows

void

@void@dolls.social

@root yea that makes sense

❤️1

Lilith Ashley Nyx Arson

@root@possum.city

@void the backfill tool is pretty damn fast too, only took about 20 minutes to index every note

void

@void@dolls.social

@root speedy,, yay :3
iceshrimp.net has 'backfilling' too but it's prolly something of their own (or not the same thing?) no idea /shrug this one here knows too less about activitypub n the fediverse as a whole

❤️1

Lilith Ashley Nyx Arson

@root@possum.city

@void its just for indexing pre-existing notes :P

mint ⏿ @mint@dissociat.ing

@root @void ironic, we just migrated dissociat.ing from meilisearch to tsvector and it's been both faster and less resource-hungry than meili!
(we're roughly within the same order of magnitude for notes stored as y'all)

❤️1

Lilith Ashley Nyx Arson

@root@possum.city

@mint @void I could try tsvec

Lilith Ashley Nyx Arson

@root@possum.city

@mint @void yeah tsvector is more than enough. nice