Re: 9.2.3 upgrade reduced pgbench performance by 60%

> -----Original Message-----
> From: pgsql-performance-owner(at)postgresql(dot)org [mailto:pgsql-
> performance-owner(at)postgresql(dot)org] On Behalf Of Josh Berkus
> Sent: Monday, March 25, 2013 4:34 PM
> To: pgsql-performance(at)postgresql(dot)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 with no 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 seeing more lock contention on updates on the 9.2 instance though.

Brad.