Re: dbt2 performance regresses from 9.1.6 to 9.2.1

From: Dong Ye <yed(at)vmware(dot)com>
To: Ants Aasma <ants(at)cybertec(dot)at>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: dbt2 performance regresses from 9.1.6 to 9.2.1
Date: 2012-11-04 22:23:17
Message-ID: 03E840D17E263A48A5766AD576E0423A03DDC5BDE7@exch-mbx-111.vmware.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> 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 got 48837.33 avg notpm with 9.1.6 and 43264.54 avg notpm with 9.2.1.
notps over time shows the slowdown of 9.2.1 is evident during the entire course of the run.
Their profiles are posted on http://pgsql.privatepaste.com/b770f72967 (9.1.6) and http://pgsql.privatepaste.com/6fa8b7f174 (9.2.1).

Thanks,
Dong

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Christoffer Lernö 2012-11-04 23:54:56 Suggested test points for a performance tool?
Previous Message Claudio Freire 2012-11-04 17:32:56 Re: Constraint exclusion in views