AW: CTE with JOIN of two tables is much faster than a regular query - Mailing list pgsql-general

> -----Ursprüngliche Nachricht-----
> Von: Tom Lane <tgl@sss.pgh.pa.us>
> Gesendet: Samstag, 18. August 2018 17:29
>
> In any case, given that the ILIKE selects so few rows (and the planner
knows
> it!), finding a way to index that is clearly the right answer.

A trigram index took 9 minutes to build but improved the regular query from
67 seconds down to 500 ms.

Although this is an impressive improvement, I'm afraid that the index might
create a delays in other parts of the application (INSERT / UPDATE). We will
probably rework the design of this particular table.

Thanks to everyone who helped me in this matter.

Regards

Klaus