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 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
