| 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-03 04:25:12 |
| Message-ID: | CAFiTN-tF00jA5yVrpq9ZipbenvszpWWh1fRdp8ZUZX1QVGvEJQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Fri, Apr 1, 2016 at 2:09 PM, Andres Freund <andres(at)anarazel(dot)de> wrote:
> One interesting thing to do would be to use -P1 during the test and see
> how much the performance varies over time.
>
I have run with -P option, I ran for 1200 second and set -P as 30 second,
and what I observed is that when its low its low throughout the run and
when its high, Its high for complete run.
Non Default Parameter:
--------------------------------
shared_buffer 8GB
Max Connections 150
./pgbench -c $threads -j $threads -T 1200 -M prepared -S -P 30 postgres
Test results are attached in result.tar file.
File details:
------------------
1. head_run1.txt --> 20 mins run on head
reading 1
2. head_run2.txt --> 20 mins run on head
reading 2
3. head_patch_run1.txt --> 20 mins run on head + patch
reading 1
4. head_patch_run2.txt --> 20 mins run on head + patch
reading 2
5. head_pinunpin.txt --> 20 mins run on head +
pinunpin-cas-8.patch
6. head_pinunpin_patch.txt --> 20 mins run on head +
pinunpin-cas-8.patch + patch reading
--
Regards,
Dilip Kumar
EnterpriseDB: http://www.enterprisedb.com
| Attachment | Content-Type | Size |
|---|---|---|
| result.tar | application/x-tar | 40.0 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alex Shulgin | 2016-04-03 04:46:06 | Re: Add schema-qualified relnames in constraint error messages. |
| Previous Message | Noah Misch | 2016-04-03 03:39:35 | Re: PostgreSQL 9.6 Feature Freeze - April 8, 2016 |