Re: 9.2.3 upgrade reduced pgbench performance by 60%

> -----Original Message-----
> From: pgsql-performance-owner@postgresql.org [mailto:pgsql-
> performance-owner@postgresql.org] On Behalf Of Josh Berkus
> Sent: Monday, March 25, 2013 4:34 PM
> To: pgsql-performance@postgresql.org
> Subject: Re: [PERFORM] 9.2.3 upgrade reduced pgbench performance by
> 60%
> 
> 
> > 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.
> 

I saw some similar results comparing 9.0 and 9.2 pgbench tests.  My tests were on a VM, but on a dedicate host/hardware
withno other VM's running on it to minimize variables. I didn't have a lot of time to dig into it, but I do recall
seeingmore lock contention on updates on the 9.2 instance though.
 


Brad.