-
-
Notifications
You must be signed in to change notification settings - Fork 1.1k
PostgreSQL full text index #1331
Copy link
Copy link
Open
Labels
Feature Requestideas for new featuresideas for new featuresSystem careEverything related to system careEverything related to system care
Milestone
Description
Specific follow-up of #302 (comment) for PostgreSQL #416 #1195
- https://www.postgresql.org/docs/current/static/textsearch-indexes.html
- https://www.depesz.com/2011/02/19/waiting-for-9-1-faster-likeilike/
Ideal goals:
- just add an index that works with existing LIKE / ILIKE SQL requests
- minor syntax changes would be ok (e.g.
lower()) - results must be returned sorted by (descending) entry.id
- avoid manually introducing new tables / columns just for the sake of the full-text search
- bonus if it is possible to delete the index for additional insert performance and reduced storage for users less interested in full-text search
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
Feature Requestideas for new featuresideas for new featuresSystem careEverything related to system careEverything related to system care