News for hackers. Stuff that matters.

A comment on What Postgres Full Text Search Is Missing. Parent comment

Re:What Postgres Full Text Search Is Missing by retakeming on Tuesday August 06, 2024 @07:05PM (#41176431)
If you're a Postgres pg_search user, partial indexes (https://docs.paradedb.com/search/full-text/index#partial-bm2...) can solve.
[ Parent | on HN ]
Re:What Postgres Full Text Search Is Missing by bastawhiz on Tuesday August 06, 2024 @08:26PM (#41176996)
If you're creating one Postgres index per user, you're going to have a bad time really fast.
[ Parent | on HN ]
Re:What Postgres Full Text Search Is Missing by sroussey on Wednesday August 07, 2024 @12:51AM (#41178340)
Would eat up inodes? Not sure how these work, does it create separate files for each one?
[ Parent | on HN ]
Re:What Postgres Full Text Search Is Missing by rco8786 on Wednesday August 07, 2024 @07:33AM (#41180281)
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.
[ Parent | on HN ]