Re: pglz performance

Поиск
Список
Период
Сортировка
От Andrey Borodin
Тема Re: pglz performance
Дата
Msg-id 60760065-1E1B-41DB-8631-810609C24218@yandex-team.ru
обсуждение исходный текст
Ответ на Re: pglz performance  (Michael Paquier <michael@paquier.xyz>)
Список pgsql-hackers

> 17 мая 2019 г., в 6:44, Michael Paquier <michael@paquier.xyz> написал(а):
>
> That's nice.
>
> From the numbers you are presenting here, all of them are much better
> than the original, and there is not much difference between any of the
> patched versions.  Having a 20%~30% improvement with a patch is very
> nice.
>
> After that comes the simplicity and the future maintainability of what
> is proposed.  I am not much into accepting a patch which has a 1%~2%
> impact for some hardwares and makes pglz much more complex and harder
> to understand.  But I am really eager to see a patch with at least a
> 10% improvement which remains simple, even more if it simplifies the
> logic used in pglz.

Here are patches for both winning versions. I'll place them on CF.
My gut feeling is pglz_decompress_hacked8 should be better, but on most architectures benchmarks show opposite.


Best regards, Andrey Borodin.



Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Lætitia Avrot
Дата:
Сообщение: Re: [Doc] pg_restore documentation didn't explain how to useconnection string
Следующее
От: Etsuro Fujita
Дата:
Сообщение: postgres_fdw: oddity in costing presorted foreign scans with local stats