Postgres Text Search Notes Revision as of Wednesday, 26 June 2024 at 10:57 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