Re: GIN improvements part2: fast scan

From: Alexander Korotkov <aekorotkov(at)gmail(dot)com>
To: Rod Taylor <rod(dot)taylor(at)gmail(dot)com>
Cc: Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: GIN improvements part2: fast scan
Date: 2013-11-15 19:42:19
Message-ID: CAPpHfdtLevt4=y_A3c+sfFT0mEM2BoeW=-SjB86-Y9M+herRow@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Nov 15, 2013 at 11:39 PM, Rod Taylor <rod(dot)taylor(at)gmail(dot)com> wrote:

>
>
>
> On Fri, Nov 15, 2013 at 2:26 PM, Alexander Korotkov <aekorotkov(at)gmail(dot)com>wrote:
>
>> On Fri, Nov 15, 2013 at 11:18 PM, Rod Taylor <rod(dot)taylor(at)gmail(dot)com>wrote:
>>
>>> 2%.
>>>
>>> It's essentially sentence fragments from 1 to 5 words in length. I
>>> wasn't expecting it to be much smaller.
>>>
>>> 10 recent value selections:
>>>
>>> white vinegar reduce color running
>>> vinegar cure uti
>>> cane vinegar acidity depends parameter
>>> how remedy fir clogged shower
>>> use vinegar sensitive skin
>>> home remedies removing rust heating
>>> does non raw apple cider
>>> home remedies help maintain healthy
>>> can vinegar mess up your
>>> apple cide vineger ph balance
>>>
>>
>> I didn't get why it's not significantly smaller. Is it possible to share
>> dump?
>>
>
> Sorry, I reported that incorrectly. It's not something I was actually
> looking for and didn't pay much attention to at the time.
>
> The patched index is 58% of the 9.4 master size. 212 MB instead of 365 MB.
>

Good. That's meet my expectations :)
You mention that both master and patched versions was compiled with debug.
Was cassert enabled?

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2013-11-15 19:47:26 Re: Wait free LW_SHARED acquisition - v0.2
Previous Message Rod Taylor 2013-11-15 19:39:18 Re: GIN improvements part2: fast scan