3 ms·

If you're a Postgres pg_search user, partial indexes (https://docs.paradedb.com/search/full-text/index#partial-bm25-index https://docs.paradedb.com/search/full-

If you're a Postgres pg_search user, partial indexes (https://docs.paradedb.com/search/full-text/index#partial-bm25-index https://docs.paradedb.com/search/full-text/index#partial-bm2...) can solve.

bastawhiz 2y ago
If you're creating one Postgres index per user, you're going to have a bad time really fast.
- sroussey 2y ago
  Would eat up inodes? Not sure how these work, does it create separate files for each one?
- rco8786 2y ago
  Index per tenant but yes, if you have hundreds or thousands of tenants that becomes a more difficult problem to manage but not at all unmanageable.