On Fri, May 4, 2012 at 3:04 PM, Merlin Moncure <mmoncure(at)gmail(dot)com> 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.
remember.guy do |as, often| as.you_can - without end
In response to
pgsql-performance by date
|Next:||From: Merlin Moncure||Date: 2012-05-09 12:53:01|
|Subject: Re: scale up (postgresql vs mssql)|
|Previous:||From: Robert Haas||Date: 2012-05-08 16:17:55|
|Subject: Re: Sudden Query slowdown on our Postgresql Server|