Re: BUG #6311: Performance degradation after upgrade

Roye Cohen wrote:
>
> The following bug has been logged online:
>
> Bug reference: 6311
> Logged by: Roye Cohen
> Email address: roye(dot)cohen(at)sap(dot)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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

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