Re: pglz performance
От | Gasper Zejn |
---|---|
Тема | Re: pglz performance |
Дата | |
Msg-id | 7d2fca56-48de-e459-2102-4a59d5f6c704@owca.info обсуждение исходный текст |
Ответ на | Re: pglz performance (Andrey Borodin <x4mmm@yandex-team.ru>) |
Ответы |
Re: pglz performance
|
Список | pgsql-hackers |
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. >
Вложения
В списке pgsql-hackers по дате отправления: