> -----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
