Re: More on 7.4b2 vs 7.3.4 performance - Mailing list pgsql-general

From Tom Lane
Subject Re: More on 7.4b2 vs 7.3.4 performance
Date
Msg-id 12629.1062451729@sss.pgh.pa.us
Whole thread Raw
In response to More on 7.4b2 vs 7.3.4 performance  (Josh Rovero <rovero@sonalysts.com>)
List pgsql-general
Josh Rovero <rovero@sonalysts.com> writes:
> There is still a average 9% improvement in 7.4b2
> transaction rates over 7.3.4.  For low number
> of clients (1 - 3) performance was almost the
> same.  For higher numbers of clients, the 7.4
> advantage was often in the 15-25% range.

This seems more believable as a version-to-version improvement factor.

I suspect that your previous numbers reflect some isolated tweak that
we made in the lock management code, that happened to reduce the amount
of time wasted in a heavy-contention scenario.  Not sure what though...

            regards, tom lane

pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: inserting via "on insert" rule
Next
From: Vivek Khera
Date:
Subject: Re: Commercial postgresql