On Monday, March 25, 2013, Colin Currie wrote:
> Hi,
>
> I recently upgraded PostgreSQL from 9.0.12 to 9.2.3 on a test server to
> compare performance. I'm using pgbench to measure which results in around a
> 60% reduction.
>
> The non-default configuration remains identical between versions excep
>
> 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.
> -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 p
> 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 th
