| From: | Jesper Pedersen <jesper(dot)pedersen(at)redhat(dot)com> |
|---|---|
| To: | Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com> |
| Cc: | Andres Freund <andres(at)anarazel(dot)de>, Pavan Deolasee <pavan(dot)deolasee(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Reduce ProcArrayLock contention |
| Date: | 2015-08-07 14:30:45 |
| Message-ID: | 55C4C115.9070101@redhat.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 08/07/2015 12:41 AM, Amit Kapila wrote:
> On Thu, Aug 6, 2015 at 9:36 PM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
>>
>>
>> OK, committed.
>>
>
> Thank you.
>
Fyi, there is something in pgbench that has caused a testing regression
- havn't tracked down what yet.
Against 9.6 server (846f8c9483a8f31e45bf949db1721706a2765771)
9.6 pgbench:
------------
progress: 10.0 s, 53525.0 tps, lat 1.485 ms stddev 0.523
progress: 20.0 s, 15750.6 tps, lat 5.077 ms stddev 1.950
...
progress: 300.0 s, 15636.9 tps, lat 5.114 ms stddev 1.989
9.5 pgbench:
------------
progress: 10.0 s, 50119.5 tps, lat 1.587 ms stddev 0.576
progress: 20.0 s, 51413.1 tps, lat 1.555 ms stddev 0.553
...
progress: 300.0 s, 52951.6 tps, lat 1.509 ms stddev 0.657
Both done with -c 80 -j 80 -M prepared -P 10 -T 300.
Just thought I would post it in this thread, because this change does
help on the performance numbers compared to 9.5 :)
Best regards,
Jesper
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Amit Kapila | 2015-08-07 14:47:28 | Re: Reduce ProcArrayLock contention |
| Previous Message | Alvaro Herrera | 2015-08-07 14:13:40 | Re: Raising our compiler requirements for 9.6 |