| From: | Dilip Kumar <dilipbalaut(at)gmail(dot)com> |
|---|---|
| To: | Andres Freund <andres(at)anarazel(dot)de> |
| Cc: | Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, 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-04-01 08:20:10 |
| Message-ID: | CAFiTN-uFOv-iXtbfToknYPKx-3Hm-T1=yCz=NGFVDj+bHWTc=Q@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thu, Mar 31, 2016 at 5:52 PM, Andres Freund <andres(at)anarazel(dot)de> wrote:
> Here's a WIP patch to evaluate. Dilip/Ashutosh, could you perhaps run
> some benchmarks, to see whether this addresses the performance issues?
>
> I guess it'd both be interesting to compare master with master + patch,
> and this thread's latest patch with the patch additionally applied.
>
I tested it in Power and seen lot of fluctuations in the reading, From this
reading I could not reach to any conclusion.
only we can say that with (patch + pinunpin), we can reach more than
600000.
I think it needs more number of runs.. After seeing this results I did not
run head+pinunpin,
Head 64 Client 128 Client
-----------------------------------------------------
Run1 434860 356945
Run2 275815 *275815*
Run3 437872 366560
Patch 64 Client 128 Client
-----------------------------------------------------
Run1 429520 372958
Run2 446249 *167189*
Run3 431066 381592
Patch+Pinunpin 64 Client 128 Client
----------------------------------------------------------
Run1 338298 642535
Run2 406240 644187
Run3 595439 *285420 *
--
Regards,
Dilip Kumar
EnterpriseDB: http://www.enterprisedb.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kyotaro HORIGUCHI | 2016-04-01 08:21:46 | Re: IF (NOT) EXISTS in psql-completion |
| Previous Message | Andres Freund | 2016-04-01 07:30:08 | Re: Incorrect format in error message |