Re: GIN improvements part2: fast scan - Mailing list pgsql-hackers

From Alexander Korotkov
Subject Re: GIN improvements part2: fast scan
Date
Msg-id CAPpHfdtLevt4=y_A3c+sfFT0mEM2BoeW=-SjB86-Y9M+herRow@mail.gmail.com
Whole thread Raw
In response to Re: GIN improvements part2: fast scan  (Rod Taylor <rod.taylor@gmail.com>)
Responses Re: GIN improvements part2: fast scan  (Alexander Korotkov <aekorotkov@gmail.com>)
Re: GIN improvements part2: fast scan  (Rod Taylor <rod.taylor@gmail.com>)
List pgsql-hackers
On Fri, Nov 15, 2013 at 11:39 PM, Rod Taylor <rod.taylor@gmail.com> wrote:



On Fri, Nov 15, 2013 at 2:26 PM, Alexander Korotkov <aekorotkov@gmail.com> wrote:
On Fri, Nov 15, 2013 at 11:18 PM, Rod Taylor <rod.taylor@gmail.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.

pgsql-hackers by date:

Previous
From: Rod Taylor
Date:
Subject: Re: GIN improvements part2: fast scan
Next
From: Andres Freund
Date:
Subject: Re: Wait free LW_SHARED acquisition - v0.2