Re: GIN improvements part 1: additional information

From: Alexander Korotkov <aekorotkov(at)gmail(dot)com>
To: Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
Cc: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Tomas Vondra <tv(at)fuzzy(dot)cz>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: GIN improvements part 1: additional information
Date: 2013-12-09 09:34:03
Message-ID: CAPpHfdvKC9HE_D+BYBUpxqyWSE4UD_=ykZgfSxkAv4P3LBFQjg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Dec 9, 2013 at 1:18 PM, Heikki Linnakangas
<hlinnakangas(at)vmware(dot)com>wrote:

> On 12/08/2013 09:56 PM, Alexander Korotkov wrote:
>
>> On Fri, Nov 29, 2013 at 11:17 PM, Heikki Linnakangas <
>> hlinnakangas(at)vmware(dot)com> wrote:
>>
>> I'll continue reviewing next week..
>>>
>>
> Got dragged into other things and didn't make any progress on this last
> week. I'm trying again now.
>
>
> Good. Thanks for debug and fixing bugs.
>> Can I do anything for this patch now?
>>
>
> I wonder if we're leaving some money on the table, by using varbyte
> encoding. Googling around, there are many other compression methods out
> there for compressing integer deltas that compress better, and/or
> decompress faster.
>

Ok, I'll try to google around. Probably, there are some better options.

> Even if we use varbyte encoding, I wonder if it would be better to treat
> block + offset number as a single 48-bit integer, rather than encode them
> separately. That would allow the delta of two items on the same page to be
> stored as a single byte, rather than two bytes. Naturally it would be a
> loss on other values, but would be nice to see some kind of an analysis on
> that. I suspect it might make the code simpler, too.

Yeah, I had that idea, but I thought it's not a better option. Will try to
do some analysis.

------
With best regards,
Alexander Korotkov.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2013-12-09 10:35:49 Re: Time-Delayed Standbys
Previous Message Heikki Linnakangas 2013-12-09 09:18:13 Re: GIN improvements part 1: additional information