GNU social JP
  • FAQ
  • Login
GNU social JPは日本のGNU socialサーバーです。
Usage/ToS/admin/test/Pleroma FE
  • Public

    • Public
    • Network
    • Groups
    • Featured
    • Popular
    • People

Conversation

Notices

  1. Embed this notice
    Rimu (rimu@mastodon.nzoss.nz)'s status on Friday, 01-Mar-2024 19:19:50 JST Rimu 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

    In conversation about a year ago from mastodon.nzoss.nz permalink
    • Embed this notice
      Rimu (rimu@mastodon.nzoss.nz)'s status on Friday, 01-Mar-2024 20:26:43 JST Rimu 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

      In conversation about a year ago permalink

      Attachments

      1. No result found on File_thumbnail lookup.
        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 Steve Purcell
      in reply to

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

      In conversation about a year ago permalink

Feeds

  • Activity Streams
  • RSS 2.0
  • Atom
  • Help
  • About
  • FAQ
  • TOS
  • Privacy
  • Source
  • Version
  • Contact

GNU social JP is a social network, courtesy of GNU social JP管理人. It runs on GNU social, version 2.0.2-dev, available under the GNU Affero General Public License.

Creative Commons Attribution 3.0 All GNU social JP content and data are available under the Creative Commons Attribution 3.0 license.