Re: More on 7.4b2 vs 7.3.4 performance

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Josh Rovero <rovero(at)sonalysts(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: More on 7.4b2 vs 7.3.4 performance
Date: 2003-09-01 21:28:49
Message-ID: 12629.1062451729@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Josh Rovero <rovero(at)sonalysts(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message 3rd. 2003-09-02 00:57:43 YOUR SITES SEARCH FEATURE DOES NOT WORK!
Previous Message Peter Eisentraut 2003-09-01 21:28:31 Re: inserting via "on insert" rule