Re: [PERFORM] dbt2 performance regresses from 9.1.6 to 9.2.1

2012-11-07 Thread Heikki Linnakangas
On 05.11.2012 16:32, Claudio Freire wrote: On Sun, Nov 4, 2012 at 7:23 PM, Dong Ye wrote: You are using prepared statements, this makes me think that this regression might be due to support for parameter specific plans for prepared statements. [1] Can you run the test on both versions without p

Re: [PERFORM] dbt2 performance regresses from 9.1.6 to 9.2.1

2012-11-05 Thread Claudio Freire
On Sun, Nov 4, 2012 at 7:23 PM, Dong Ye wrote: >> You are using prepared statements, this makes me think that this >> regression might be due to support for parameter specific plans for >> prepared statements. [1] Can you run the test on both versions without >> prepared statements and see if the

Re: [PERFORM] dbt2 performance regresses from 9.1.6 to 9.2.1

2012-11-05 Thread Dong Ye
> You are using prepared statements, this makes me think that this > regression might be due to support for parameter specific plans for > prepared statements. [1] Can you run the test on both versions without > prepared statements and see if the regressions remains. Without prepare statement, we

Re: [PERFORM] dbt2 performance regresses from 9.1.6 to 9.2.1

2012-11-02 Thread Ants Aasma
On Thu, Nov 1, 2012 at 12:51 AM, Dong Ye wrote: > The average notpm is 61384.24 with 9.1.6 and 57381.43 with 9.2.1. > Plotting notps over time shows that the slowdown of 9.2.1 is evident across > the entire run period. > Since we also observed sustained 80+% CPU utilization during both runs, we