Re: Asymmetric partition-wise JOIN - Mailing list pgsql-hackers

From Andrey Lepikhov
Subject Re: Asymmetric partition-wise JOIN
Date
Msg-id 33b92be7-67ca-ac4a-35be-48a673d74dd9@postgrespro.ru
Whole thread Raw
In response to Re: Asymmetric partition-wise JOIN  (Zhihong Yu <zyu@yugabyte.com>)
Responses Re: Asymmetric partition-wise JOIN  (Alexander Pyhalov <a.pyhalov@postgrespro.ru>)
List pgsql-hackers
On 5/7/21 23:15, Zhihong Yu wrote:
> On Mon, Jul 5, 2021 at 2:57 AM Andrey Lepikhov 
> <a.lepikhov@postgrespro.ru <mailto:a.lepikhov@postgrespro.ru>> wrote:
> +            * Can't imagine situation when join relation already 
> exists. But in
> +            * the 'partition_join' regression test it happens.
> +            * It may be an indicator of possible problems.
> Should a log be added in the above case ?
I made additional analysis of this branch of code. This situation can 
happen in the case of one child or if we join two plane tables with 
partitioned. Both situations are legal and I think we don't needed to 
add any log message here.
Other mistakes were fixed.

-- 
regards,
Andrey Lepikhov
Postgres Professional

Attachment

pgsql-hackers by date:

Previous
From: David Rowley
Date:
Subject: Re: [PATCH] expand the units that pg_size_pretty supports on output
Next
From: Dilip Kumar
Date:
Subject: Re: [Proposal] Fully WAL logged CREATE DATABASE - No Checkpoints