condition it takes too much time ,
What should we do for better performance?
Use WITH (Common Table Expressions)
is select ... where like '%value%' equally slow? Look into pg_trgm indexing
Fir this need to install new extension?
Using LIKE or ILIKE starting with % is slow even if the column is indexed. An index is only used, when the condition ends with %. If you want to make the other one fast, take a look at https://www.postgresql.org/docs/current/textsearch.html
Обсуждают сегодня