Re: GIN improvements part2: fast scan

Поиск
Список
Период
Сортировка
От Alexander Korotkov
Тема Re: GIN improvements part2: fast scan
Дата
Msg-id CAPpHfdvt2SAB+f+qTfYRMviQmhmdhYvJzKep5XkdUNgf8K_NWg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: GIN improvements part2: fast scan  (Alexander Korotkov <aekorotkov@gmail.com>)
Список pgsql-hackers
On Fri, Nov 15, 2013 at 11:42 PM, Alexander Korotkov <aekorotkov@gmail.com> wrote:
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?

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

------
With best regards,
Alexander Korotkov.
Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Changing pg_dump default file format
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Suggestion: Issue warning when calling SET TRANSACTION outside transaction block