BUG #6311: Performance degradation after upgrade

From: "Roye Cohen" <roye(dot)cohen(at)sap(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6311: Performance degradation after upgrade
Date: 2011-11-27 12:40:24
Message-ID: 201111271240.pARCeOJd050321@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


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.

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.

Best regards,

Roye

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2011-11-27 13:26:16 Re: BUG #6311: Performance degradation after upgrade
Previous Message Craig Ringer 2011-11-27 08:59:34 Re: BUG #6308: Problem w. encoding in client