Re: Optimizing pglz compressor

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: Optimizing pglz compressor
Дата
Msg-id 51CA0155.9030903@vmware.com
обсуждение исходный текст
Ответ на Re: Optimizing pglz compressor  (Amit Kapila <amit.kapila@huawei.com>)
Ответы Re: Optimizing pglz compressor  (Amit Kapila <amit.kapila@huawei.com>)
Список pgsql-hackers
On 19.06.2013 14:01, Amit Kapila wrote:
> Observations
> --------------
> 1. For small data perforamce is always good with patch.
> 2. For random small/large data performace is good.
> 3. For medium and large text and same byte data(3K,5K text, 10K,100K,500K
> same byte), performance is degraded.

Wow, that's strange. What platform and CPU did you test on? Are you sure
you used the same compiler flags with and without the patch?

Can you also try the attached patch, please? It's the same as before,
but in this version, I didn't replace the prev and next pointers in
PGLZ_HistEntry struct with int16s. That avoids some table lookups, at
the expense of using more memory. It's closer to what we have without
the patch, so maybe that helps on your system.

- Heikki

Вложения

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

Предыдущее
От: Claudio Freire
Дата:
Сообщение: Re: Hash partitioning.
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: XLogInsert scaling, revisited