Re: Slow query after upgrade from 9.0 to 9.2

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: Andrzej Zawadzki <zawadaa(at)wp(dot)pl>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Slow query after upgrade from 9.0 to 9.2
Date: 2013-01-10 18:17:21
Message-ID: CAMkU=1wFT5q_XyQstPMA-nw5kiC4f_uwZg_YgLpLoN=LDrtT3g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thu, Jan 10, 2013 at 5:32 AM, Andrzej Zawadzki <zawadaa(at)wp(dot)pl> wrote:
>
> Why that's happens? All configurations are identical. Only engine is
> different.

Could you post explain (analyze, buffers) instead of just explain?
Also, if you temporarily set enable_seqscan=off on 9.2, what plan do
you then get?

Cheers,

Jeff

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Matheus de Oliveira 2013-01-10 18:45:43 Partition insert trigger using C language
Previous Message PostgreSQL 2013-01-10 18:04:02 Updates on one row causing ExclusiveLock on PostgreSQL 8.3.5