Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Support conditional indexes for pg_search #1012

Open
neilyio opened this issue Mar 28, 2024 · 0 comments
Open

Support conditional indexes for pg_search #1012

neilyio opened this issue Mar 28, 2024 · 0 comments
Labels
feature New feature or request pg_search Issue related to `pg_search/` priority-3-low Low priority issue

Comments

@neilyio
Copy link
Contributor

neilyio commented Mar 28, 2024

What
create_bm25 should adopt a where parameter to support conditional / partial indexes:
https://www.postgresql.org/docs/current/indexes-partial.html

Why
Relevant feature request in community Slack:
https://paradedbcommunity.slack.com/archives/C05M7JPPDN1/p1711606230397599

Example use case:

Thinking of the use case where I have a multi-tenant b2b SaaS DB and my tenant identifier is a uuid type representing each of my business customer's being another organisation with their own cohort of users accessing their tenanted data on our SaaS.

How
We might be able to just expose a where parameter on create_bm25 to pass to the CREATE INDEX call.
@neilyio neilyio added feature New feature or request priority-3-low Low priority issue pg_search Issue related to `pg_search/` labels Mar 28, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
feature New feature or request pg_search Issue related to `pg_search/` priority-3-low Low priority issue
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@neilyio