About the ORM icontains operator's disadvantage on PostgreSQL performance and query results.

2021-02-27 Thread Mesut Öncel
Hi, I opened the ticket https://code.djangoproject.com/ticket/3575. In this ticket, I wanted to prove the effect of UPPER function used in icontains operator on indexes and query result. UPPER function causes performance problems regarding indexing in PostgreSQL. Another issue is that it does n

Re: About the ORM icontains operator's disadvantage on PostgreSQL performance and query results.

2021-02-27 Thread Tom Forbes
Hey, I think it would be best if you opened a new ticket explaining your issue and the performance problems you’ve found (especially around Turkish characters). I’m not entirely clear what you wish to be changed: you wish for an expression index to be created automatically? Tom On Sat, 27 Feb 202