From: Gasper Zejn <zejn@owca.info>
To: pgsql-hackers@lists.postgresql.org
Subject: Re: pglz performance
Date: Fri, 17 May 2019 15:40:57 +0200
Message-ID: <7d2fca56-48de-e459-2102-4a59d5f6c704@owca.info> (raw)
In-Reply-To: <2035A8B0-AB54-4ADB-BEFE-ADABEC7BDADF@yandex-team.ru>
References: <469C9ED9-348C-4FE7-A7A7-B0FA671BEE4C@yandex-team.ru>
<20190513071427.GB2273@paquier.xyz>
<446036FB-EA13-4F18-B593-70EDE0A35366@yandex-team.ru>
<2035A8B0-AB54-4ADB-BEFE-ADABEC7BDADF@yandex-team.ru>
On 16. 05. 19 19:13, Andrey Borodin wrote:
>
>> 15 мая 2019 г., в 15:06, Andrey Borodin <x4mmm@yandex-team.ru> написал(а):
>>
>> Owners of AMD and ARM devices are welcome.
I've tested according to instructions at the test repo
https://github.com/x4m/test_pglz
Test_pglz is at a97f63b and postgres at 6ba500.
Hardware is desktop AMD Ryzen 5 2600, 32GB RAM
Decompressor score (summ of all times):
NOTICE: Decompressor pglz_decompress_hacked result 6.988909
NOTICE: Decompressor pglz_decompress_hacked8 result 7.562619
NOTICE: Decompressor pglz_decompress_hacked16 result 8.316957
NOTICE: Decompressor pglz_decompress_vanilla result 10.725826
Attached is the full test run, if needed.
Kind regards,
Gasper
> Yandex hardware RND guys gave me ARM server and Power9 server. They are looking for AMD and some new Intel boxes.
>
> Meanwhile I made some enhancements to test suit:
> 1. I've added Shakespeare payload: concatenation of works of this prominent poet.
> 2. For each payload compute "sliced time" - time to decompress payload if it was sliced by 2Kb pieces or 8Kb pieces.
> 3. For each decompressor we compute "score": (sum of time to decompress each payload, each payload sliced by 2Kb and 8Kb) * 5 times
>
> I've attached full test logs, meanwhile here's results for different platforms.
>
> Intel Server
> NOTICE: 00000: Decompressor pglz_decompress_hacked result 10.346763
> NOTICE: 00000: Decompressor pglz_decompress_hacked8 result 11.192078
> NOTICE: 00000: Decompressor pglz_decompress_hacked16 result 11.957727
> NOTICE: 00000: Decompressor pglz_decompress_vanilla result 14.262256
>
> ARM Server
> NOTICE: Decompressor pglz_decompress_hacked result 12.966668
> NOTICE: Decompressor pglz_decompress_hacked8 result 13.004935
> NOTICE: Decompressor pglz_decompress_hacked16 result 13.043015
> NOTICE: Decompressor pglz_decompress_vanilla result 18.239242
>
> Power9 Server
> NOTICE: Decompressor pglz_decompress_hacked result 10.992974
> NOTICE: Decompressor pglz_decompress_hacked8 result 11.747443
> NOTICE: Decompressor pglz_decompress_hacked16 result 11.026342
> NOTICE: Decompressor pglz_decompress_vanilla result 16.375315
>
> Intel laptop
> NOTICE: Decompressor pglz_decompress_hacked result 9.445808
> NOTICE: Decompressor pglz_decompress_hacked8 result 9.105360
> NOTICE: Decompressor pglz_decompress_hacked16 result 9.621833
> NOTICE: Decompressor pglz_decompress_vanilla result 10.661968
>
> From these results pglz_decompress_hacked looks best.
>
> Best regards, Andrey Borodin.
>
Attachments:
pglz_benchmarks_amd.txt (text/plain, 83.0K) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: zejn@owca.info, pgsql-hackers@lists.postgresql.org
Subject: Re: pglz performance
In-Reply-To: <7d2fca56-48de-e459-2102-4a59d5f6c704@owca.info>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox