On Wed, May 9, 2012 at 2:11 AM, Robert Klemme <shortcutter@xxxxxxxxxxxxxx> wrote: > 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. yeah -- perhaps a CTE might work as well. merlin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
