Re: Partition-wise join with whole row vars

From: Alexander Pyhalov <a(dot)pyhalov(at)postgrespro(dot)ru>
To: Dmitry Dolgov <9erthalion6(at)gmail(dot)com>
Cc: Michael Paquier <michael(at)paquier(dot)xyz>, Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>, Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com>
Subject: Re: Partition-wise join with whole row vars
Date: 2024-12-04 06:59:10
Message-ID: dfe2031412085e376c95b6887a63e4ac@postgrespro.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Dmitry Dolgov писал(а) 2024-12-02 16:39:
>> On Tue, Oct 08, 2024 at 09:24:15AM GMT, Alexander Pyhalov wrote:
>>
>> Attaching rebased patches.
>
> Just to let you know, looks like CFBot tests are red again, but this
> time there are some unexpected differences in some test query plan.

Hi, updated patches. The differences in plans were likely caused by

commit 161320b4b960ee4fe918959be6529ae9b106ea5a
Author: David Rowley <drowley(at)postgresql(dot)org>
Date: Fri Oct 11 17:19:59 2024 +1300

Adjust EXPLAIN's output for disabled nodes

which changed explain output format.
--
Best regards,
Alexander Pyhalov,
Postgres Professional

Attachment Content-Type Size
0006-postgres_fdw-fix-partition-wise-DML.patch text/x-diff 22.6 KB
0005-postgres_fdw-child-join-with-ConvertRowtypeExprs-cau.patch text/x-diff 25.7 KB
0004-Compare-converted-whole-row-vars-in-search_indexed_t.patch text/x-diff 13.5 KB
0003-Handle-child-relation-s-ConvertRowtypeExpr-in-find_c.patch text/x-diff 1.3 KB
0002-Handle-ConvertRowtypeExprs-in-pull_vars_clause.patch text/x-diff 6.2 KB
0001-Allow-partition-wise-join-when-reltarget-contains-wh.patch text/x-diff 6.3 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2024-12-04 07:03:17 Re: Contradictory behavior of array_agg(distinct) aggregate.
Previous Message Konstantin Knizhnik 2024-12-04 06:44:07 Contradictory behavior of array_agg(distinct) aggregate.