Re: No index only scan on md5 index - Mailing list pgsql-performance

From Albe Laurenz
Subject Re: No index only scan on md5 index
Date
Msg-id A737B7A37273E048B164557ADEF4A58B50FEB3D6@ntex2010i.host.magwien.gv.at
Whole thread Raw
In response to Re: No index only scan on md5 index  (Adam Brusselback <adambrusselback@gmail.com>)
List pgsql-performance
Adam Brusselback wrote:
> I appreciate the response Tom, and you are correct that the workaround would not work in my case.
> 
> So no index expressions can return the their value without recomputing without that work around?  I
> learn something new every day it seems.
> Thank you for the alternate method.

No, what Tom said is that the check whether an "index only scan" was feasible
or not does not consider expressions.

Yours,
Laurenz Albe

pgsql-performance by date:

Previous
From: Adam Brusselback
Date:
Subject: Re: No index only scan on md5 index
Next
From: Glyn Astill
Date:
Subject: Index scan cost calculation