Re: Index only scans for expressional indices when querying for the expression

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Danny Shemesh <dany74q(at)gmail(dot)com>
Cc: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Index only scans for expressional indices when querying for the expression
Date: 2022-08-04 14:17:11
Message-ID: 3445972.1659622631@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Danny Shemesh <dany74q(at)gmail(dot)com> writes:
> Do you think there'd be room to accept a contribution for such
> functionality with a disabled-by-default pg setting,
> or are you skeptical it would ever be worth the trade-off ?

If you can show me a matching algorithm with non-exponential runtime,
I'd be interested.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Marco Lechner 2022-08-04 15:44:05 follower never to become master
Previous Message Danny Shemesh 2022-08-04 14:03:22 Re: Index only scans for expressional indices when querying for the expression