Hi, On 2025-06-20 09:46:06 +0800, James Pang wrote: > same OS RHEL8, install pgv14.11 and pgv18.beta1_3, both installation by RPM > from pgdg, and use similar postgresql.conf. >
> 14.11 > Time: 55.082 ms > postgres=# select * from tt where b ~~ 'a%'; > a | b > ---+--- > (0 rows) > > Time: 54.716 ms > 18.beta1 > postgres=# select * from tt where b ~~ 'a%'; > a | b > ---+--- > (0 rows) > > Time: 77.117 ms I tried but failed to reproduce this. In fact, I see both 17 and 18 being faster than 14. Have you checked if 14 and 18 actually use the same collation? Greetings, Andres Freund
