Re: Move PinBuffer and UnpinBuffer to atomics

From: Alexander Korotkov <a(dot)korotkov(at)postgrespro(dot)ru>
To: Andres Freund <andres(at)anarazel(dot)de>
Cc: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Dilip Kumar <dilipbalaut(at)gmail(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Merlin Moncure <mmoncure(at)gmail(dot)com>, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, YUriy Zhuravlev <u(dot)zhuravlev(at)postgrespro(dot)ru>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Move PinBuffer and UnpinBuffer to atomics
Date: 2016-03-31 20:14:15
Message-ID: CAPpHfduTE2xnCX3t7hj8mpAmFuKcQSYKK1FGe4UhD=8MwpL2Hg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Mar 31, 2016 at 8:21 PM, Alexander Korotkov <
a(dot)korotkov(at)postgrespro(dot)ru> wrote:

>
> I think these changes worth running benchmark again. I'm going to run it
> on 4x18 Intel.
>

The results are following.

clients master v3 v5 v9
1 11671 12507 12679 12408
2 24650 26005 25010 25495
4 49631 48863 49811 50150
8 96790 96441 99946 98383
10 121275 119928 124100 124180
20 243066 243365 246432 248723
30 359616 342241 357310 378881
40 431375 415310 441619 425653
50 489991 489896 500590 502549
60 538057 636473 554069 685010
70 588659 714426 738535 719383
80 405008 923039 902632 909126
90 295443 1181247 1155918 1179163
100 258695 1323125 1325019 1351578
110 238842 1393767 1410274 1421531
120 226018 1432504 1474982 1497122
130 215102 1465459 1503241 1521619
140 206415 1470454 1505380 1541816
150 197850 1475479 1519908 1515017
160 190935 1420915 1484868 1523150
170 185835 1438965 1453128 1499913
180 182519 1416252 1453098 1472945

It appears that atomic OR for LockBufHdr() gives small but measurable
effect. Great idea, Andres!

------
Alexander Korotkov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company

Attachment Content-Type Size
image/png 39.4 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2016-03-31 20:34:07 Re: improving GROUP BY estimation
Previous Message Alvaro Herrera 2016-03-31 19:45:56 Re: [PATCH v9] GSSAPI encryption support