| From: | Jesper Pedersen <jesper(dot)pedersen(at)redhat(dot)com> |
|---|---|
| To: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Sokolov Yura <funny(dot)falcon(at)postgrespro(dot)ru>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Fix performance of generic atomics |
| Date: | 2017-09-06 17:41:27 |
| Message-ID: | 0effb79a-fc34-f59d-ddab-d65c720a4257@redhat.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi Jeff,
On 09/05/2017 03:47 PM, Jeff Janes wrote:
>> I ran pgbench (-M prepared) with synchronous_commit 'on' and 'off' using
>> both logged and unlogged tables. Also ran an internal benchmark which
>> didn't show anything either.
>>
>
> What scale factor and client count? How many cores per socket? It looks
> like Sokolov was just starting to see gains at 200 clients on 72 cores,
> using -N transaction.
I have done a run with scale factor 300, and another with 3000 on a
2S/28C/56T/256Gb w/ 2 x RAID10 SSD machine; up to 200 clients.
I would consider the runs as "noise" as I'm seeing +-1% for all client
counts, so nothing like Yura is seeing in [1] for the higher client counts.
I did a run with -N too using scale factor 300, using the settings in
[1], but with same result (+-1%).
[1]
https://www.postgresql.org/message-id/d62d7d9d473d07e172d799d5a57e70be@postgrespro.ru
Best regards,
Jesper
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jacob Champion | 2017-09-06 17:45:25 | Re: [PATCH] Add citext_pattern_ops to citext contrib module |
| Previous Message | Simon Riggs | 2017-09-06 17:33:59 | Re: ALTER INDEX .. SET STATISTICS ... behaviour |