Re: [PERFORM] Slow query after upgrade from 9.0 to 9.2

2013-01-11 Thread Jeff Janes
On Fri, Jan 11, 2013 at 12:13 AM, Andrzej Zawadzki wrote: > On 10.01.2013 19:17, Jeff Janes wrote: >> Also, if you temporarily set enable_seqscan=off on 9.2, what plan do >> you then get? > > Plan is different. > > "Join Filter: (sa.arrear_import_id = ai.id)" It is hard to imagi

Re: [PERFORM] Slow query after upgrade from 9.0 to 9.2

2013-01-11 Thread Andrzej Zawadzki
On 10.01.2013 19:48, Matheus de Oliveira wrote: > > > On Thu, Jan 10, 2013 at 11:32 AM, Andrzej Zawadzki > wrote: > > Hi! > > Small query run on 9.0 very fast: > > SELECT * from sygma_arrear sar where sar.arrear_import_id = ( > select sa.arrear_import_

Re: [PERFORM] Slow query after upgrade from 9.0 to 9.2

2013-01-11 Thread Andrzej Zawadzki
On 10.01.2013 19:17, Jeff Janes wrote: > On Thu, Jan 10, 2013 at 5:32 AM, Andrzej Zawadzki wrote: >> Why that's happens? All configurations are identical. Only engine is >> different. > Could you post explain (analyze, buffers) instead of just explain? Impossible, 1h of waiting and I've killed tha

Re: [PERFORM] Slow query after upgrade from 9.0 to 9.2

2013-01-10 Thread Matheus de Oliveira
On Thu, Jan 10, 2013 at 11:32 AM, Andrzej Zawadzki wrote: > Hi! > > Small query run on 9.0 very fast: > > SELECT * from sygma_arrear sar where sar.arrear_import_id = ( > select sa.arrear_import_id from sygma_arrear sa, arrear_import ai > where sa.arrear_flag_id = 2 > AND s

Re: [PERFORM] Slow query after upgrade from 9.0 to 9.2

2013-01-10 Thread Jeff Janes
On Thu, Jan 10, 2013 at 5:32 AM, Andrzej Zawadzki 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? Che

[PERFORM] Slow query after upgrade from 9.0 to 9.2

2013-01-10 Thread Andrzej Zawadzki
Hi! Small query run on 9.0 very fast: SELECT * from sygma_arrear sar where sar.arrear_import_id = ( select sa.arrear_import_id from sygma_arrear sa, arrear_import ai where sa.arrear_flag_id = 2 AND sa.arrear_import_id = ai.id AND ai.import_type_id = 1 order