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

From Dilip Kumar
Subject Re: Move PinBuffer and UnpinBuffer to atomics
Date
Msg-id CAFiTN-vkMu0P2sRyvt6H9W_C0h=_ewQPf9aLnXC2XtDV7u=-7g@mail.gmail.com
Whole thread Raw
In response to Re: Move PinBuffer and UnpinBuffer to atomics  (Andres Freund <andres@anarazel.de>)
Responses Re: Move PinBuffer and UnpinBuffer to atomics
List pgsql-hackers
<div dir="ltr"><div class="gmail_extra"><br /><div class="gmail_quote">On Sat, Feb 27, 2016 at 5:14 AM, Andres Freund
<spandir="ltr"><<a href="mailto:andres@anarazel.de" target="_blank">andres@anarazel.de</a>></span> wrote:<br
/><blockquoteclass="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid
rgb(204,204,204);padding-left:1ex"><spanclass="">> > > >> ./pgbench  -j$ -c$ -T300 -M prepared -S
postgres<br/> > > > >><br /> > > > >> Client    Base    Patch<br /> > > >
>>1    17169    16454<br /> > > > >> 8    108547    105559<br /> > > > >> 32   
241619   262818<br /> > > > >> 64    206868    233606<br /> > > > >> 128    137084   
217013<br/> > ><br /> > > So, there's a small regression on low client counts. That's worth<br /> > >
addressing.<br/> > ><br /> ><br /> > Interesting. I'll try to reproduce it.<br /><br /></span>Any progress
here?</blockquote></div><br/></div><div class="gmail_extra">In Multi socket machine with 8 sockets and 64 cores, I have
seenmore regression compared to my previous run in power8 with 2 socket, currently I tested Read only workload for 5
minsRun, When I get time, I will run for longer time and confirm again.<br /><br /><span class="im">Shared Buffer=
8GB<br/> Scale Factor=300</span><br /><br /><span class="">./pgbench  -j$ -c$ -T300 -M prepared -S postgres</span><br
/>client        base        patch<br />1               7057         5230<br />2             10043         9573<br
/>4            20140        18188<br /></div><div class="gmail_extra"><br clear="all" /><br />-- <br /><div
class="gmail_signature"><divdir="ltr"><span style="color:rgb(80,0,80);font-size:12.8px">Regards,</span><br
style="color:rgb(80,0,80);font-size:12.8px"/><span style="color:rgb(80,0,80);font-size:12.8px">Dilip Kumar</span><br
style="color:rgb(80,0,80);font-size:12.8px"/><span style="color:rgb(80,0,80);font-size:12.8px">EnterpriseDB: </span><a
href="http://www.enterprisedb.com/"style="color:rgb(17,85,204);font-size:12.8px"
target="_blank">http://www.enterprisedb.com</a><br/></div></div></div></div> 

pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Re: [COMMITTERS] pgsql: Respect TEMP_CONFIG when running contrib regression tests.
Next
From: Simon Riggs
Date:
Subject: Re: The plan for FDW-based sharding