Re: pglz performance
От | Andrey Borodin |
---|---|
Тема | Re: pglz performance |
Дата | |
Msg-id | 2035A8B0-AB54-4ADB-BEFE-ADABEC7BDADF@yandex-team.ru обсуждение исходный текст |
Ответ на | Re: pglz performance (Andrey Borodin <x4mmm@yandex-team.ru>) |
Ответы |
Re: pglz performance
Re: pglz performance |
Список | pgsql-hackers |
> 15 мая 2019 г., в 15:06, Andrey Borodin <x4mmm@yandex-team.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.
Вложения
В списке pgsql-hackers по дате отправления: