Conversation

Notices

1. Embed this notice
   Rimu (rimu@mastodon.nzoss.nz)'s status on Friday, 01-Mar-2024 19:19:50 JST Rimu

   Added full-text search to #PieFed today.

   After reading a massive tome about #ElasticSearch earlier this week I realised it was complete overkill and just used the full-text capabilities of #PostgreSQL instead.

   Currently PieFed has 46,000 posts and results are fast. It'll be interesting to see how well it copes when there are more posts. Anyone want to make a guess when it'll bog down?

   https://piefed.social/post/48889

   • Embed this notice
     Rimu (rimu@mastodon.nzoss.nz)'s status on Friday, 01-Mar-2024 20:26:43 JST Rimu

     in reply to

     • Steve Purcell

     @sanityinc I *think* there's GIN involved - the module I'm using mentions them in the code... Line 239 https://github.com/falcony-io/sqlalchemy-searchable/blob/master/sqlalchemy_searchable/__init__.py

   • Embed this notice
     Steve Purcell (sanityinc@hachyderm.io)'s status on Friday, 01-Mar-2024 20:26:44 JST Steve Purcell

     in reply to

     @rimu If you've got GIN indexes set up then you'll probably never need a different search solution