Re: Wait free LW_SHARED acquisition - v0.9 - Mailing list pgsql-hackers

Hi,

On 2014-10-11 07:26:57 +0530, Amit Kapila wrote:
> On Sat, Oct 11, 2014 at 7:00 AM, Andres Freund <andres@2ndquadrant.com>
> > And since
> > your general performance numbers are a fair bit lower than what I see
> > with, hopefully, the same code on the same machine...
> 
> You have reported numbers at 1000 scale factor and mine were
> at 3000 scale factor, so I think the difference is expected.

The numbers for 3000 show pretty much the same:

SCALE        128        160        175
HEAD        352113        339005        336491
LW_SHARED    365874        347931        342528

Hm. I wonder if you're using pgbench without -M prepared? That'd about
explain the difference.

Greetings,

Andres Freund

-- Andres Freund                       http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training &
Services