Re: Problem, partition pruning for prepared statement with IS NULL clause.

Поиск
Список
Период
Сортировка
От Sergei Glukhov
Тема Re: Problem, partition pruning for prepared statement with IS NULL clause.
Дата
Msg-id 5845262d-9b6a-71f7-3485-c06e4977586f@postgrespro.ru
обсуждение исходный текст
Ответ на Re: Problem, partition pruning for prepared statement with IS NULL clause.  (David Rowley <dgrowleyml@gmail.com>)
Ответы Re: Problem, partition pruning for prepared statement with IS NULL clause.
Список pgsql-hackers
Hi,

Thanks for fixing this!

I verified that issues are fixed.

On 10/11/23 11:50, David Rowley wrote:

> I'm aiming to commit these as two separate fixes, so I'm going to go
> look again at the first one and wait to see if anyone wants to comment
> on this patch in the meantime.

Regarding test case for the first patch,
the line 'set plan_cache_mode = 'force_generic_plan';' is not necessary
since cache mode is set at the top of the test. On the other hand test
scenario can silently  be loosed if someone set another cache mode
somewhere upper. As you mentioned earlier it's worth maybe adding
the test for run-time partition pruning.

Regards,
Gluh




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

Предыдущее
От: tender wang
Дата:
Сообщение: Re: Problem, partition pruning for prepared statement with IS NULL clause.
Следующее
От: Peter Smith
Дата:
Сообщение: Re: Add null termination to string received in parallel apply worker