Skip to content

PostgreSQL full text index #1331

@Alkarex

Description

@Alkarex

Specific follow-up of #302 (comment) for PostgreSQL #416 #1195

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    Feature Requestideas for new featuresSystem careEverything related to system care

    Type

    No type

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions