Performance issue with "LIKE" operator for PostgreSQL driver [#3231303]

The PostgreSQL driver map LIKE operator with "ILIKE". This behavior could cause performance issues.

It would be better to use "LIKE BINARY" operator to generate condition for tag_ids for PostgreSQL.

Comment	File	Size	Author
#2	postgresql-performance-issues-3231303-2.patch	724 bytes	papajo

Comments

3 September 2021 at 15:48

papajo created an issue. See original summary.

papajo commented 3 September 2021 at 16:19

Status	File	Size
new	postgresql-performance-issues-3231303-2.patch	724 bytes

Here is a patch to use "LIKE BINARY" instead of "LIKE" for PostgreSQL.