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-11-26 13:34:12 |
Message-ID: | CAPpHfdvG+EvY26-bRAj=FzUUSm+O+9gc0g7PmM1fupxy2Ycv3g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi!
On Wed, Nov 20, 2013 at 9:02 PM, Heikki Linnakangas <hlinnakangas(at)vmware(dot)com
> wrote:
> On 06.11.2013 17:36, Alvaro Herrera wrote:
>
>> Just for my own illumination, can someone explain this bit?
>>
>> + If a posting list is too large to store in-line in a key entry, a
>> posting tree
>> + is created. A posting tree is a B-tree structure, where the ItemPointer
>> is
>> + used as the key. At the leaf-level, item pointers are stored
>> compressed, in
>> + "varbyte encoding".
>>
>> I think the first ItemPointer mentioned (the key) refers to a TID
>> pointing to the index, and "item pointers stored compressed" refers to
>> the TIDs pointing to the heap (the data). Is that correct?
>>
>
> No, they both refer to TIDs pointing to the heap.
>
>
> I'm also interested in the "FIXME explain varbyte encoding" explanation
>> currently missing, if somebody can write it down ...
>>
>
> Alexander's latest version filled in that explanation (haven't read it
> myself yet)
off-list
What's your plans about GIN now? I tried to rebase packed posting lists
with head. But I found that you've changed interface of placeToPage
function. That's conflicts with packed posting lists, because
dataPlaceToPageLeaf needs not only offset number to describe place to
insert item pointer. Do you like to commit rework of handling GIN
incomplete splits before?
------
With best regards,
Alexander Korotkov.
From | Date | Subject | |
---|---|---|---|
Next Message | Alexander Korotkov | 2013-11-26 13:35:50 | Re: GIN improvements part 1: additional information |
Previous Message | Amit Khandekar | 2013-11-26 13:29:24 | Re: COPY table FROM STDIN doesn't show count tag |