Problem/Motivation

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

Proposed resolution

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

CommentFileSizeAuthor
#2 postgresql-performance-issues-3231303-2.patch724 bytespapajo

Comments

papajo created an issue. See original summary.

papajo’s picture

papajo commented
StatusFileSize
new postgresql-performance-issues-3231303-2.patch724 bytes

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