Re: Wait free LW_SHARED acquisition - v0.9

From: Andres Freund <andres(at)2ndquadrant(dot)com>
To: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Robert Haas <robertmhaas(at)gmail(dot)com>
Subject: Re: Wait free LW_SHARED acquisition - v0.9
Date: 2014-10-11 13:10:45
Message-ID: 20141011131045.GC18020@awork2.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)2ndquadrant(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2014-10-11 13:32:15 Re: Add CREATE support to event triggers
Previous Message Peter Eisentraut 2014-10-11 13:07:46 Re: orangutan seizes up during isolation-check