link The fuzzystrmatch module provides several functions to determine similarities and distance between strings.
link The pg_trgm module provides functions and operators for determining the similarity of alphanumeric text based on trigram matching, as well as index operator classes that support fast searching for similar strings.
link Full Text Search with PostgreSQL and Rails for the love.
link Postgres full-text search is Good Enough!
link Full text search in milliseconds with PostgreSQL.
link Indexing for full text search in PostgreSQL.
link POSTGRESQL: A FULL TEXT SEARCH ENGINE
link Fast Search Using PostgreSQL Trigram Indexes.
link From LIKE to Full-Text Search.
[link] (https://www.citusdata.com/blog/2016/11/04/autovacuum-not-the-enemy/) autovacuum-not-the-enemy
[link] (https://lob.com/blog/supercharge-your-postgresql-performance/) Slow PostgreSQL Performance? Don’t Forget to Vacuum your Database
[link] (http://okigiveup.net/postgresql-vacuuming-an-introduction-for-busy-devs/) PostgreSQL Vacuuming: An Introduction for Busy Devsi