Postgres Pro
Downloads
Home   >   mailing lists

Re: Slow query after upgrade from 9.0 to 9.2 - Mailing list pgsql-performance

From Jeff Janes
Subject Re: Slow query after upgrade from 9.0 to 9.2
Date
Msg-id CAMkU=1wFT5q_XyQstPMA-nw5kiC4f_uwZg_YgLpLoN=LDrtT3g@mail.gmail.com
Whole thread Raw
In response to Slow query after upgrade from 9.0 to 9.2  (Andrzej Zawadzki <zawadaa@wp.pl>)
Responses Re: Slow query after upgrade from 9.0 to 9.2  (Andrzej Zawadzki <zawadaa@wp.pl>)
List pgsql-performance
Tree view 
On Thu, Jan 10, 2013 at 5:32 AM, Andrzej Zawadzki <zawadaa@wp.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

pgsql-performance by date:

Previous
From: PostgreSQL
Date:
Subject: Updates on one row causing ExclusiveLock on PostgreSQL 8.3.5
Next
From: Matheus de Oliveira
Date:
Subject: Partition insert trigger using C language