Re: BUG #6311: Performance degradation after upgrade - Mailing list pgsql-bugs

From Bruce Momjian
Subject Re: BUG #6311: Performance degradation after upgrade
Date
Msg-id 201111271326.pARDQGh10264@momjian.us
Whole thread Raw
In response to BUG #6311: Performance degradation after upgrade  ("Roye Cohen" <roye.cohen@sap.com>)
List pgsql-bugs
Roye Cohen wrote:
>
> The following bug has been logged online:
>
> Bug reference:      6311
> Logged by:          Roye Cohen
> Email address:      roye.cohen@sap.com
> PostgreSQL version: 9.1.1
> Operating system:   Linux Redhat
> Description:        Performance degradation after upgrade
> Details:
>
> Hi,
>
> I am a performance engineer. I was conducting a comparison from postgres 9.0
> to 9.1.1 in order to upgrade to the newest version.
> I found a degradation in physical memory used on DB server (~200%
> degradation) and a small degradation in  response times on every transaction
> monitored in comparison to 9.0.

I am confused by the word "degradation".  You mean that Postgres 9.1
used 3x more memory than PG 9.0?  How much slower was it?

> The test was done on HP LoadRunner with 300 concurrent users executing a
> flow of events.
>
> The exact sequence of steps is hard to describe but it is important to
> state that the executions were exactly the same. Default postgres settings
> were used (settings were not changed after installing postgres).
>
>
> OS Version: Linux 2.6.18-164.el5 x86_64
>
> I am at your service if you have any further inqueries.

We have certainly never heard of a report like this between PG 9.0 and
9.1, so I am confused.  Was their any change in the client interface
software between the two tests?

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +

pgsql-bugs by date:

Previous
From: "Roye Cohen"
Date:
Subject: BUG #6311: Performance degradation after upgrade
Next
From: "Kevin Grittner"
Date:
Subject: Re: BUG #6311: Performance degradation after upgrade