> -----Original Message-----
> From: pgsql-performance-ow...@postgresql.org [mailto:pgsql-
> performance-ow...@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 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. 

-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

Reply via email to