On 18 October 2012 17:52, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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?
--
Peter Geoghegan http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training and Services