Postgres Full Text Search

Summary

Implement postgres' [full text search](

Basic Example

_No response_

Motivation

You cannot index fields bigger than 2704 chars, which is laughably small for any blog-like environment.

We are seeing errors like:


Detailed Design

When a field is marked as "indexed" and the field type is "text" switch from using normal b-tree based index in postgres to full text search, and use ts_vector for it.

Requirements List

Must Have:

• Index search for text fields of bigger size


Drawbacks

It would mean redoing some search queries, but would ultimately add more flexability in using directus search _directly_ by users

Alternatives

Elastic search implementation

Adoption Strategy

.

Unresolved Questions

_No response_