On 18 October 2012 18:00, Peter Geoghegan <peter@2ndquadrant.com> wrote:
> On 18 October 2012 17:52, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> I forgot to mention that there is a klugy workaround: add the required
>> variable(s) as extra index columns. That is,
>>
>> create index i on t (foo(x), x);
>
> Is there a case to be made for a index access method whose
> pseudo-indexes costs essentially nothing to maintain, and simply
> represent an ongoing obligation for ANALYZE to provide statistics for
> an expression?
Heh, that's pretty much the question I posted just a few seconds ago.
--
Thom