Postgres Text Search Notes Revision as of Tuesday, 22 June 2021 at 22:22 UTC

Postgres Text Search Notes

Substring Searching

“Left-anchored search patterns”

https://www.depesz.com/2011/02/19/waiting-for-9-1-faster-likeilike/

FTS (Fulltexte Search)

Levenstein

https://www.postgresql.org/docs/11/fuzzystrmatch.html#id-1.11.7.24.6

Parsing queries

https://www.postgresql.org/docs/11/textsearch-controls.html#TEXTSEARCH-PARSING-QUERIES

Two excellent resources

• https://www.compose.com/articles/indexing-for-full-text-search-in-postgresql/
• http://rachbelaid.com/postgres-full-text-search-is-good-enough/