Re: Reduce ProcArrayLock contention
| От | Amit Kapila |
|---|---|
| Тема | Re: Reduce ProcArrayLock contention |
| Дата | |
| Msg-id | CAA4eK1KSjO_Me7xtCFFJVyAPcypzkgJaW0NtjhyBKcenZzXFkw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Reduce ProcArrayLock contention (Jesper Pedersen <jesper.pedersen@redhat.com>) |
| Ответы |
Re: Reduce ProcArrayLock contention
Re: Reduce ProcArrayLock contention |
| Список | pgsql-hackers |
On Fri, Aug 7, 2015 at 8:00 PM, Jesper Pedersen <jesper.pedersen@redhat.com> wrote:
On 08/07/2015 12:41 AM, Amit Kapila wrote:On Thu, Aug 6, 2015 at 9:36 PM, Robert Haas <robertmhaas@gmail.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.
I will look into it.
Could you please share some of the settings used for test like
scale_factor in pgbench and shared_buffers settings or if you
have changed any other default setting in postgresql.conf?
В списке pgsql-hackers по дате отправления: