On 18 October 2012 18:00, Peter Geoghegan <pe...@2ndquadrant.com> wrote: > On 18 October 2012 17:52, Tom Lane <t...@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 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance