Conversation

Notices

1. Embed this notice
   feld (feld@friedcheese.us)'s status on Thursday, 05-Sep-2024 09:03:31 JST feld

   • on-lain ✔ᵛᵉʳᶦᶠᶦᵉᵈ
   • :blank:
   • Phantasm
   • ロミンちゃん
   @i @phnt @lain @romin if you want to see what the query looks like it would be something like this
   
   
   EXPLAIN ANALYZE SELECT o.id FROM objects o WHERE o.data ->> 'content'::text @@ websearch_to_tsquery('english', 'crappy performance') LIMIT 10;
   
   
   i guess we gotta dig in and figure out why it's misbehaving
   • Embed this notice
     feld (feld@friedcheese.us)'s status on Thursday, 05-Sep-2024 10:55:44 JST feld

     in reply to

     • on-lain ✔ᵛᵉʳᶦᶠᶦᵉᵈ
     • :blank:
     • Phantasm
     • ロミンちゃん
     @i @lain @phnt @romin Dumped the whole raw query with all our search filters etc and discovered it's our filter on public posts that's breaking search for this here.
     
     AND ($1 && a0."recipients")
     
     the $1 it's checking recipients for: {"https://www.w3.org/ns/activitystreams#Public", "https://bikeshed.party/#Public"}
     
     cut that out of the query and I'm getting the match to show!
     
     the recipients being returned from that query when it DOES match because I removed that filter:
     
     {https://fluffytail.org/users/phnt,https://friedcheese.us/users/feld/followers,https://lain.com/users/lain,https://shitposter.world/users/romin,https://
     friedcheese.us/users/feld}
     
     Interesting...