Re: selecting from partitions and constraint exclusion

Поиск
Список
Период
Сортировка
От Amit Langote
Тема Re: selecting from partitions and constraint exclusion
Дата
Msg-id 30d8b287-b570-9258-ba81-6cc44f0fbf7c@lab.ntt.co.jp
обсуждение исходный текст
Ответ на Re: selecting from partitions and constraint exclusion  (Thibaut <thibaut.madelaine@dalibo.com>)
Список pgsql-hackers
Hi Thibaut,

On 2019/04/06 1:12, Thibaut wrote:
> Le 25/03/2019 à 01:31, Amit Langote a écrit :
>> On 2019/03/22 17:17, Amit Langote wrote:
>>> I'll add this to July fest to avoid forgetting about this.
>> I'd forgotten to do this, but done today. :)
>>
>> Thanks,
>> Amit
> 
> Hello Amit,
> 
> Just a quick information that your last patch does not apply on head:
> 
> $ git apply
> ~/Téléchargements/v2-0001-Fix-planner-to-load-partition-constraint-in-some-.patch
> error: patch failed: src/test/regress/expected/partition_prune.out:3637
> error: src/test/regress/expected/partition_prune.out: patch does not apply
> 
> Manually applying it on top of Hosoya's last 2 patches, It corrects the
> different cases we found so far.
> I will keep on testing next week.

Thanks for the heads up.

We are discussing this and another related matter on a different thread
(titled "speeding up planning with partitions" [1]).  Maybe, the problem
originally reported here will get resolved there once we reach consensus
first on what to do in the HEAD branch and what's back-patchable as a
bug-fix to the PG 11 branch.

[1]
https://www.postgresql.org/message-id/50415da6-0258-d135-2ba4-197041b57c5b%40lab.ntt.co.jp




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

Предыдущее
От: 'Andres Freund'
Дата:
Сообщение: Re: reloption to prevent VACUUM from truncating empty pages at theend of relation
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: lazy_scan_heap() forgets to mark buffer dirty when setting allfrozen?