Re: Move PinBuffer and UnpinBuffer to atomics - Mailing list pgsql-hackers

From Merlin Moncure
Subject Re: Move PinBuffer and UnpinBuffer to atomics
Date
Msg-id CAHyXU0xXU_xxeJaSjy-dBBRpGpR16q1k_U1LKd+=mERcNXomfg@mail.gmail.com
Whole thread Raw
In response to Re: Move PinBuffer and UnpinBuffer to atomics  (Alexander Korotkov <a.korotkov@postgrespro.ru>)
Responses Re: Move PinBuffer and UnpinBuffer to atomics  (Dilip Kumar <dilipbalaut@gmail.com>)
List pgsql-hackers
On Fri, Jan 29, 2016 at 3:17 PM, Alexander Korotkov
<a.korotkov@postgrespro.ru> wrote:
> Hi, Dilip!
>
> On Tue, Jan 19, 2016 at 6:00 PM, Dilip Kumar <dilipbalaut@gmail.com> wrote:
>>
>>
>> On Tue, Jan 19, 2016 at 5:44 PM, Michael Paquier
>> <michael.paquier@gmail.com> wrote:
>>>
>>> > Test3:
>>> > pgbench -i -s 100 postgres
>>> > pgbench -c$ -j$ -Mprepared -S postgres
>>> >
>>> > Client             Base                      Pached
>>> >
>>> > 1                      20555                    19404
>>> > 32                  375919                  332670
>>> > 64                  509067                  440680
>>> > 128                431346                  415121
>>> > 256                380926                  379176
>>>
>>> It seems like you did a copy-paste of the results with s=100 and
>>> s=300. Both are showing the exact same numbers.
>>
>>
>> Oops, my mistake, re-pasting the correct results for s=100
>>
>> pgbench -i -s 100 postgres
>> pgbench -c$ -j$ -Mprepared -S postgres
>>
>> Client             Base                      Pached
>>
>> 1                    20548                    20791
>> 32                  372633                  355356
>> 64                  532052                  552148
>> 128                412755                  478826
>> 256                 346701                 372057
>
>
> Could you please re-run these tests few times?
> Just to be sure it's a reproducible regression with s=300 and not a
> statistical error.

Probably want to run for at least 5 minutes via -T 300

merlin



pgsql-hackers by date:

Previous
From: Alexander Korotkov
Date:
Subject: Re: Move PinBuffer and UnpinBuffer to atomics
Next
From: Alexander Korotkov
Date:
Subject: Re: Optimizer questions