PostgreSQL. Using and optimizing trigram search

Question

PostgreSQL

Good day!

Is the respected habrapublic interested in trigram search (search with typos in words), as an extension for PostgreSQL? Would you be interested in an article describing the extension, installing the extension, optimizing work for several million records, etc.? Without bringing comparative characteristics with other search engines, only within Postgres.

Thank you!

Answer 1

I think the article will be of interest to many. I myself use PostgreSQL in my projects and there is a project with a search in millions of records with support for typos in the plans.

Answer 2

Yes, it will be interesting.

Answer 3

Interesting.

Answer 4

Write. Will you be using pg_trgm in this article ? Index support?

Answer 5

Necessary!