postgres 9.2
Hi all,
I recently ran a couple of tests where I took one of my production
systems and did a drop-in replacement of postgres 8.4 with 9.2.4.
I was expecting to see some performance improvement given the release
notes describing 9.2 as a "largely performance related release".
At least for my application, which is an embedded postgresql install
with a relatively small number of client connections, I'm not seeing much
of a measurable difference at all.
I'm just wondering if others have had a similar experience where upgrading
from 8.x to 9.x has or has not improved overall performance?
Thanks.
On 08/27/2013 02:26 PM, pg noob wrote:
Hi all,
I recently ran a couple of tests where I took one of my production
systems and did a drop-in replacement of postgres 8.4 with 9.2.4.
I was expecting to see some performance improvement given the release
notes describing 9.2 as a "largely performance related release".At least for my application, which is an embedded postgresql install
with a relatively small number of client connections, I'm not seeing much
of a measurable difference at all.I'm just wondering if others have had a similar experience where upgrading
from 8.x to 9.x has or has not improved overall performance?
It would be easier to answer if you gave some information on what
performance you are measuring and what the results are?
Also remember there is an overhead incurred for all operations and for
small installations it is a bigger part of the total cost, so you will
not really gain on that.
Thanks.
--
Adrian Klaver
adrian.klaver@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Tue, Aug 27, 2013 at 2:26 PM, pg noob <pgnube@gmail.com> wrote:
Hi all,
I recently ran a couple of tests where I took one of my production
systems and did a drop-in replacement of postgres 8.4 with 9.2.4.
I was expecting to see some performance improvement given the release
notes describing 9.2 as a "largely performance related release".At least for my application, which is an embedded postgresql install
with a relatively small number of client connections, I'm not seeing much
of a measurable difference at all.
There were a bunch of different, specific, performance improvements
each with a focused area. Many of them related to reducing contention
in many-CPU systems. If your system wasn't having problems in the
specific areas that were improved, you wouldn't see an improvement.
Cheers,
Jeff
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general