From: | Gasper Zejn <zejn(at)owca(dot)info> |
---|---|
To: | pgsql-hackers(at)lists(dot)postgresql(dot)org |
Subject: | Re: pglz performance |
Date: | 2019-05-17 13:40:57 |
Message-ID: | 7d2fca56-48de-e459-2102-4a59d5f6c704@owca.info |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 16. 05. 19 19:13, Andrey Borodin wrote:
>
>> 15 мая 2019 г., в 15:06, Andrey Borodin <x4mmm(at)yandex-team(dot)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.
>
Attachment | Content-Type | Size |
---|---|---|
pglz_benchmarks_amd.txt | text/plain | 83.0 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2019-05-17 14:16:26 | Re: PostgreSQL 12: Feature Highlights |
Previous Message | RAJIN RAJ K | 2019-05-17 13:28:02 | Table as argument in postgres function |