Re: Terribly slow query with very good plan?

From: Nick Cleaton <nick(at)cleaton(dot)net>
To: Les <nagylzs(at)gmail(dot)com>
Cc: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Terribly slow query with very good plan?
Date: 2022-02-04 13:57:08
Message-ID: CAFgz3kvCosDhgU=5Qq-RfVQDMCwCryOxp_OUmZ18mp1yJ6Gsyw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Fri, 4 Feb 2022 at 13:21, Les <nagylzs(at)gmail(dot)com> wrote:
>
>> What if you try applying the C collation to the values from the table:
>>
>> where fi.is_active and fi.relpath collate "C" ^@ 'A'
>
>
> Slow

What about this:

fi.relpath between ('A' collate "C") and ('A'||chr(255) collate "C")

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Les 2022-02-04 14:07:10 Re: Terribly slow query with very good plan?
Previous Message Ninad Shah 2022-02-04 13:33:16 Re: Terribly slow query with very good plan?