wow amazing I figured out how to fix Pleroma search. It's not perfect but it actually has results for many things that had no results before
Timeline
Post
Remote status
Replies
8
@feld external search db provider(?)
here it is in all its glory lol we shot ourselves in the dick years ago and forgot about it
https://git.pleroma.social/pleroma/pleroma/pulls/7845/commits/82fc3a4c5609d0c93a8d03b6b9c49da7ce862edd
https://git.pleroma.social/pleroma/pleroma/pulls/7845/commits/82fc3a4c5609d0c93a8d03b6b9c49da7ce862edd
@feld whatd you do? drop /add some indexs?
@doti well we had made a bunch of improvements to the search query stuff that in theory was more correct but we left a setting enabled for Postgres GIN that limited results as a side effect
also I optimized performance for people who have a TON of blocked users as the query plan wasn't optimal, and we should probably do this same trick in a bunch of other places in the codebase.
also I optimized performance for people who have a TON of blocked users as the query plan wasn't optimal, and we should probably do this same trick in a bunch of other places in the codebase.
here it is in all its glory lol we shot ourselves in the dick years ago and forgot about it
https://git.pleroma.social/pleroma/pleroma/pulls/7845/commits/82fc3a4c5609d0c93a8d03b6b9c49da7ce862edd
https://git.pleroma.social/pleroma/pleroma/pulls/7845/commits/82fc3a4c5609d0c93a8d03b6b9c49da7ce862edd
@doti I feel like I have amnesia and every 2 years or so I think there's a simple explanation we are overlooking
https://git.pleroma.social/pleroma/pleroma/pulls/6650#issuecomment-112202
I've done it again
https://git.pleroma.social/pleroma/pleroma/pulls/6650#issuecomment-112202
I've done it again
@feld Also makes me wonder if we should revisit Postgres JIT in the near-ish future. There's been some talks about implementing JIT cache which hasn't been implemented yet I think.