Tom Lane <tgl@sss.pgh.pa.us>, 30 Ara 2025 Sal, 09:51 tarihinde şunu yazdı:
>The fundamental problem here is not wanting to make assumptions about >which character strings a non-deterministic collation will consider >equal to which other character strings. If you have concrete ideas >about how to improve that, let's hear them.
Thanks for the explanations. I am just a user, not a DB developer :) So no ideas I am afraid. I was just surprised that running the lower() function on every column of every row is way faster than using nondeterministic collation. I will test GIN index with trigram to see if it helps. If not I will leave the code as is with lower() functions.
Чтобы сделать работу с сайтом удобнее, мы используем cookie и аналитический сервис «Яндекс.Метрика». Продолжая пользоваться сайтом, вы соглашаетесь с их использованием.