Re: GIN improvements part 1: additional information
От | Alexander Korotkov |
---|---|
Тема | Re: GIN improvements part 1: additional information |
Дата | |
Msg-id | CAPpHfdvXET0Jk=-oWNGGywMZqbiWML4kg9=GvGY8Yruvbhe4BQ@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: GIN improvements part 1: additional information (Alexander Korotkov <aekorotkov@gmail.com>) |
Ответы |
Re: GIN improvements part 1: additional information
Re: GIN improvements part 1: additional information |
Список | pgsql-hackers |
On Mon, Oct 21, 2013 at 11:12 PM, Alexander Korotkov <aekorotkov@gmail.com> wrote:
------
With best regards,
Alexander Korotkov.
Attached version of patch is debugged. I would like to note that number of bugs was low and it wasn't very hard to debug. I've rerun tests on it. You can see that numbers are improved as the result of your refactoring.event | period-----------------------+-----------------index_build | 00:01:45.416822index_build_recovery | 00:00:06index_update | 00:05:17.263606index_update_recovery | 00:01:22search_new | 00:24:07.706482search_updated | 00:26:25.364494(6 rows)label | blocks_mark----------------+-------------search_new | 847587636search_updated | 881210486(2 rows)label | size---------------+-----------new | 419299328after_updates | 715915264(2 rows)Beside simple bugs, there was a subtle bug in incremental item indexes update. I've added some more comments including ASCII picture about how item indexes are shifted.Now, I'm trying to implement support of old page format. Then we can decide which approach to use.
Attached version of patch has support of old page format. Patch still needs more documentation and probably refactoring, but I believe idea is clear and it can be reviewed. In the patch I have to revert change of null category placement for compatibility with old posting list format.
------
With best regards,
Alexander Korotkov.
Вложения
В списке pgsql-hackers по дате отправления: