Re: [WIP PATCH] Index scan offset optimisation using visibility map

Поиск
Список
Период
Сортировка
От Michail Nikolaev
Тема Re: [WIP PATCH] Index scan offset optimisation using visibility map
Дата
Msg-id CANtu0ogYYFP8A+rC311NKfoM8EDQSYLqhxj1Z7e7ZW2XpwQ3RQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [WIP PATCH] Index scan offset optimisation using visibility map  (Andrey Borodin <x4mmm@yandex-team.ru>)
Ответы Re: [WIP PATCH] Index scan offset optimisation using visibility map  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: [WIP PATCH] Index scan offset optimisation using visibility map  (Andrey Borodin <x4mmm@yandex-team.ru>)
Список pgsql-hackers
Hello.

Thanks a lot for review.

Patch updated + rebased on master. check-world is passing.

Still not sure about comment formatting. Have you seen any style guid about it except "strict ANSI C comment formatting"? Anyway still need to work on comments.

Also, non-MVCC snaphots are now supported.


Still not sure about questions 0, 2, 3, 4, 5, and 6 from initial mail (about explain, explain analyze, documentation and optimiser).

Thanks.

пн, 5 февр. 2018 г. в 23:36, Andrey Borodin <x4mmm@yandex-team.ru>:
Hi, Michail!

Thanks for the patch!

> 1 февр. 2018 г., в 1:17, Michail Nikolaev <michail.nikolaev@gmail.com> написал(а):
>
> Hello.
>
> WIP-Patch for optimisation of OFFSET + IndexScan using visibility map.

While the patch seems to me useful improvement, I see few problems with code:
1. Both branches of "if (node->iss_tuples_skipped_remaning != 0)" seem too similar. There is a lot of duplicate comments et c. I think that this branch should be refactored to avoid code duplication.
2. Most of comments are formatted not per project style.

Besides this, patch looks good. Please, add it to the following commitfest so that work on the patch could be tracked.

Best regards, Andrey Borodin.
Вложения

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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: JIT compiling with LLVM v9.0
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [WIP PATCH] Index scan offset optimisation using visibility map