Re: 9.2.3 upgrade reduced pgbench performance by 60% - Mailing list pgsql-performance

From Josh Berkus
Subject Re: 9.2.3 upgrade reduced pgbench performance by 60%
Date
Msg-id 5150B4D0.3020902@agliodbs.com
Whole thread Raw
In response to 9.2.3 upgrade reduced pgbench performance by 60%  (Colin Currie <colin@marketsworld.com>)
Responses Re: 9.2.3 upgrade reduced pgbench performance by 60%  ("Nicholson, Brad (Toronto, ON, CA)" <bnicholson@hp.com>)
List pgsql-performance
> The Linux server is on a cloud and has 4GB RAM and 2 CPUs and the
> same server is running both master and slave (these are separate in
> production). If you'd like any more details please ask. Here are the
> pgbench results:

Presumably you created a new cloud server for 9.2, yes?  I'd guess that
the difference is between the two cloud servers.  Try testing, for
example, bonnie++ on the two servers.

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com


pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Setting vacuum_freeze_min_age really low
Next
From: Andrea Suisani
Date:
Subject: [OT] linux 3.10 kernel will improve ipc,sysv semaphore scalability