From: | Andrey Borodin <x4mmm(at)yandex-team(dot)ru> |
---|---|
To: | Michael Paquier <michael(at)paquier(dot)xyz> |
Cc: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Vladimir Leskov <vladimirlesk(at)yandex-team(dot)ru> |
Subject: | Re: pglz performance |
Date: | 2019-05-16 17:13:22 |
Message-ID: | 2035A8B0-AB54-4ADB-BEFE-ADABEC7BDADF@yandex-team.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> 15 мая 2019 г., в 15:06, Andrey Borodin <x4mmm(at)yandex-team(dot)ru> написал(а):
>
> Owners of AMD and ARM devices are welcome.
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.txt | text/plain | 24.4 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Chapman Flack | 2019-05-16 17:26:41 | Re: PSA: New intel MDS vulnerability mitigations cause measurable slowdown |
Previous Message | Tomas Vondra | 2019-05-16 16:39:47 | Re: Avoiding hash join batch explosions with extreme skew and weird stats |