On Fri, May 4, 2012 at 3:04 PM, Merlin Moncure <mmoncure@xxxxxxxxx> wrote: > let's see the query plan...when you turned it off, did it go faster? > put your suspicious plans here: http://explain.depesz.com/ I suggest to post three plans: 1. insert into temp table 2. access to temp table before analyze 3. access to temp table after analyze Maybe getting rid of the temp table (e.g. using a view or even an inline view) is even better than optimizing temp table access. Kind regards robert -- remember.guy do |as, often| as.you_can - without end http://blog.rubybestpractices.com/ -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
