Обсуждение: postgres 9.2

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

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