Re: Partition-wise join with whole row vars

Alexander Pyhalov <a.pyhalov@postgrespro.ru>

From: Alexander Pyhalov <a.pyhalov@postgrespro.ru>

To: Dmitry Dolgov <9erthalion6@gmail.com>

Cc: Michael Paquier <michael@paquier.xyz>, Pgsql Hackers <pgsql-hackers@postgresql.org>, Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>

Date: 2024-12-04T06:59:10Z

Lists: pgsql-hackers

Attachments

0006-postgres_fdw-fix-partition-wise-DML.patch (text/x-diff)
0005-postgres_fdw-child-join-with-ConvertRowtypeExprs-cau.patch (text/x-diff)
0004-Compare-converted-whole-row-vars-in-search_indexed_t.patch (text/x-diff)
0003-Handle-child-relation-s-ConvertRowtypeExpr-in-find_c.patch (text/x-diff)
0002-Handle-ConvertRowtypeExprs-in-pull_vars_clause.patch (text/x-diff)
0001-Allow-partition-wise-join-when-reltarget-contains-wh.patch (text/x-diff)

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@postgresql.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