Re: Performing partition pruning using row value

Поиск
Список
Период
Сортировка
От David Steele
Тема Re: Performing partition pruning using row value
Дата
Msg-id 69c1a22a-508a-bbb2-8968-7677a05f9b03@pgmasters.net
обсуждение исходный текст
Ответ на Re: Performing partition pruning using row value  (Anastasia Lubennikova <a.lubennikova@postgrespro.ru>)
Список pgsql-hackers
On 2/16/21 9:07 AM, Anastasia Lubennikova wrote:
> On 21.07.2020 11:24, kato-sho@fujitsu.com wrote:
>>> So, after looking at these functions and modifying this patch, I 
>>> would like to add this patch to the next
>> I updated this patch and registered for the next CF .
>>
>> https://commitfest.postgresql.org/29/2654/
>>
>> regards,
>> sho kato
> 
> Thank you for working on this improvement. I took a look at the code.
> 
> 1) This piece of code is unneeded:
> 
>              switch (get_op_opfamily_strategy(opno, partopfamily))
>              {
>                  case BTLessStrategyNumber:
>                  case BTLessEqualStrategyNumber:
>                  case BTGreaterEqualStrategyNumber:
>                  case BTGreaterStrategyNumber:
> 
> See the comment for RowCompareExpr, which states that "A RowCompareExpr 
> node is only generated for the < <= > >= cases".
> 
> 2) It's worth to add a regression test for this feature.
> 
> Other than that, the patch looks good to me.

This patch has been Waiting on Author for several months, so marking 
Returned with Feedback.

Please resubmit to the next CF when you have a new patch.

Regards,
-- 
-David
david@pgmasters.net



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

Предыдущее
От: Tomas Vondra
Дата:
Сообщение: Re: maximum columns for brin bloom indexes
Следующее
От: David Steele
Дата:
Сообщение: Re: [PATCH] Add support for ON UPDATE/DELETE actions on ALTER CONSTRAINT