On 18 October 2012 17:24, Peter Geoghegan <peter@xxxxxxxxxxxxxxx> wrote: > On 18 October 2012 17:11, Thom Brown <thom@xxxxxxxxx> wrote: >> The estimate is down to almost a 10th of what it was before. What's going on? > > Even though the index isn't used, the pg_statistic entries that the > expression index would have made available are. It's as if you > materialised the expression into a column, analyzed and grouped by > that. D'oh, of course! Thanks Peter. -- Thom -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
