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