Re: Optimizing pglz compressor - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: Optimizing pglz compressor
Date
Msg-id 51CA0155.9030903@vmware.com
Whole thread Raw
In response to Re: Optimizing pglz compressor  (Amit Kapila <amit.kapila@huawei.com>)
Responses Re: Optimizing pglz compressor
List 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

Attachment

pgsql-hackers by date:

Previous
From: Claudio Freire
Date:
Subject: Re: Hash partitioning.
Next
From: Jeff Janes
Date:
Subject: Re: XLogInsert scaling, revisited