On 18 October 2012 17:52, Tom Lane <tgl@xxxxxxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
