Re: scale up (postgresql vs mssql) - Mailing list pgsql-performance

From Merlin Moncure
Subject Re: scale up (postgresql vs mssql)
Date
Msg-id CAHyXU0wHndzyvo+WmLdu0V6Xhj5cCdVCumf3qZShxHYh5RFFxg@mail.gmail.com
Whole thread Raw
In response to Re: scale up (postgresql vs mssql)  (Robert Klemme <shortcutter@googlemail.com>)
List pgsql-performance
On Wed, May 9, 2012 at 2:11 AM, Robert Klemme
<shortcutter@googlemail.com> wrote:
> On Fri, May 4, 2012 at 3:04 PM, Merlin Moncure <mmoncure@gmail.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.

merlin

pgsql-performance by date:

Previous
From: Robert Klemme
Date:
Subject: Re: scale up (postgresql vs mssql)
Next
From: "MauMau"
Date:
Subject: Could synchronous streaming replication really degrade the performance of the primary?