On: Full text search over Postgres: Elasticsearch vs. ...

[cpursley]

I haven't used LLMs but am using a hybrid approach with pg_vector: https://github.com/agoodway/vecto (some useful links in the README).

One way that comes to mind is using LLMs is to re-write the query before shoving it into the search engine (known as "query rewriting").

More full-text ideas here: https://gist.github.com/cpursley/c8fb81fe8a7e5df038158bdfe0f...