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-18 20:28:35
Message-ID: CAPpHfdvt2SAB+f+qTfYRMviQmhmdhYvJzKep5XkdUNgf8K_NWg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Nov 15, 2013 at 11:42 PM, Alexander Korotkov
<aekorotkov(at)gmail(dot)com>wrote:

> 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?
>

In the attached version of patch tsvector opclass is enabled to use
fastscan. You can retry your tests.

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

Attachment Content-Type Size
gin-fast-scan.7.patch.gz application/x-gzip 9.1 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2013-11-18 20:42:10 Re: Suggestion: Issue warning when calling SET TRANSACTION outside transaction block
Previous Message Bruce Momjian 2013-11-18 20:21:08 Re: Changing pg_dump default file format