Re: LWLock optimization for multicore Power machines

From: Bernd Helmle <mailings(at)oopsware(dot)de>
To: Alexander Korotkov <a(dot)korotkov(at)postgrespro(dot)ru>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: LWLock optimization for multicore Power machines
Date: 2017-02-21 10:47:33
Message-ID: 1487674053.3143.1.camel@oopsware.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Am Samstag, den 11.02.2017, 15:42 +0300 schrieb Alexander Korotkov:
> I think it would make sense to run more kinds of tests.  Could you
> try set
> of tests provided by Tomas Vondra?
> If even we wouldn't see win some of the tests, it would be still
> valuable
> to see that there is no regression there.

Sorry for the delay.

But here are the results after having run Tomas' benchmarks scripts.
The pgbench-ro benchmark shows a clear win of the lwlock-power-3 patch,
also you see a slight advantage of this patch in the pgbench-rw graph.
At least, i don't see any signifikant regression somewhere.

The graphs are showing the average values over all five runs for each
client count.

Attachment Content-Type Size
image/png 25.6 KB
image/png 27.9 KB
image/png 25.5 KB
image/png 26.8 KB
image/png 26.1 KB
image/png 24.8 KB
results.csv text/csv 33.0 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alexander Korotkov 2017-02-21 10:51:13 Re: Should we cacheline align PGXACT?
Previous Message Rushabh Lathia 2017-02-21 10:31:54 Re: Push down more UPDATEs/DELETEs in postgres_fdw