If you're creating one Postgres index per user, you're going to have a bad time ... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		bastawhiz 12 months ago \| parent \| context \| favorite \| on: Full text search over Postgres: Elasticsearch vs. ... If you're creating one Postgres index per user, you're going to have a bad time really fast.

sroussey 12 months ago | [–]

Would eat up inodes? Not sure how these work, does it create separate files for each one?

rco8786 12 months 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.

Consider applying for YC's Fall 2025 batch! Applications are open till Aug 4
Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact