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@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general