On 30-12-2011 19:35, Merlin Moncure wrote:
try this (curious):
create table pos as select n from generate_series(1,32) n;
and swap that for the in-query generate series call. your statistics
in the query are completely off (not 100% sure why), so I'm thinking
to replace that since it lies to the planner about the # rows
returned. also the join on the array element probably isn't helping.
merlin
Tried it. The query still takes around the same amount of time but, out
of curiosity, here's the explain analyze of it:
http://explain.depesz.com/s/MvE .
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
