Thank you all for such super quick responses. We are considering removing the pg_trgm index and hope that will help!
On Wed, Oct 19, 2022 at 4:36 PM Andres Freund <andres@anarazel.de> wrote:
Hi,
On 2022-10-19 13:20:37 -0700, Peter Geoghegan wrote: > On Wed, Oct 19, 2022 at 1:12 PM Andres Freund <andres@anarazel.de> wrote: > > The reason you're seeing this in 14 is likely the following entry in the > > release notes: > > > > > Allow GiST/GIN pg_trgm indexes to do equality lookups (Julien Rouhaud) > > > This is similar to LIKE except no wildcards are honored. > > > > CCed author/committer of that change. I suspect this would need proper costing > > to not be inadvertently be used. > > I am reminded of this recent thread: > > https://postgr.es/m/3188617.44csPzL39Z@aivenronan > > (Perhaps you were thinking of the same thing already, but thought I'd > mention it, just in case.)
No, I hadn't seen that one. That indeed looks quite relevant...