Postgres how to do efficient db lookup?

Question

PostgreSQL

Please advise materials on Postgres, parsing search and its optimization is especially important. preferably in Russian, but if there is directly ideal material in English, I will start reading it

Answer 1

See what you are looking for. Full-text search is one thing, search for fuzzy duplicates is another, search for an entry in directories is a third, faceted is a fourth.
In general, gin index with pg_trgm