| From: | Dilip Kumar <dilipbalaut(at)gmail(dot)com> |
|---|---|
| To: | Andres Freund <andres(at)anarazel(dot)de> |
| Cc: | Alexander Korotkov <a(dot)korotkov(at)postgrespro(dot)ru>, Merlin Moncure <mmoncure(at)gmail(dot)com>, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, Amit Kapila <amit(dot)kapila16(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-02-28 15:35:29 |
| Message-ID: | CAFiTN-vkMu0P2sRyvt6H9W_C0h=_ewQPf9aLnXC2XtDV7u=-7g@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Sat, Feb 27, 2016 at 5:14 AM, Andres Freund <andres(at)anarazel(dot)de> wrote:
> > > > >> ./pgbench -j$ -c$ -T300 -M prepared -S postgres
> > > > >>
> > > > >> Client Base Patch
> > > > >> 1 17169 16454
> > > > >> 8 108547 105559
> > > > >> 32 241619 262818
> > > > >> 64 206868 233606
> > > > >> 128 137084 217013
> > >
> > > So, there's a small regression on low client counts. That's worth
> > > addressing.
> > >
> >
> > Interesting. I'll try to reproduce it.
>
> Any progress here?
In Multi socket machine with 8 sockets and 64 cores, I have seen more
regression compared to my previous run in power8 with 2 socket, currently I
tested Read only workload for 5 mins Run, When I get time, I will run for
longer time and confirm again.
Shared Buffer= 8GB
Scale Factor=300
./pgbench -j$ -c$ -T300 -M prepared -S postgres
client base patch
1 7057 5230
2 10043 9573
4 20140 18188
--
Regards,
Dilip Kumar
EnterpriseDB: http://www.enterprisedb.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2016-02-28 18:21:57 | Re: The plan for FDW-based sharding |
| Previous Message | Andrew Dunstan | 2016-02-28 14:43:00 | Re: Re: [COMMITTERS] pgsql: Respect TEMP_CONFIG when running contrib regression tests. |