On Wed, May 9, 2012 at 2:11 AM, Robert Klemme
> 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.
yeah -- perhaps a CTE might work as well.
In response to
pgsql-performance by date
|Next:||From: MauMau||Date: 2012-05-09 13:06:17|
|Subject: Could synchronous streaming replication really degrade the performance of the primary?|
|Previous:||From: Robert Klemme||Date: 2012-05-09 07:11:42|
|Subject: Re: scale up (postgresql vs mssql)|