Re: [HACKERS] Add support for tuple routing to foreign partitions - Mailing list pgsql-hackers

From Robert Haas
Subject Re: [HACKERS] Add support for tuple routing to foreign partitions
Date
Msg-id CA+TgmoZUxbZMdYkuwKGXqnoGg9WH51pm5y0uHO1As27svZY4Zw@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] Add support for tuple routing to foreign partitions  (Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>)
Responses Re: [HACKERS] Add support for tuple routing to foreign partitions
List pgsql-hackers
On Sun, Aug 20, 2017 at 11:25 PM, Etsuro Fujita
<fujita.etsuro@lab.ntt.co.jp> wrote:
>> I agree, but I wonder if we ought to make it work first using the
>> existing APIs and then add these new APIs as an optimization.
>
> I'm not sure that's a good idea because that once we support INSERT
> tuple-routing for foreign partitions, we would have a workaround: INSERT
> INTO partitioned_table SELECT * from data_table where data_table is a
> foreign table defined for an input file using file_fdw.

That's true, but I don't see how it refutes the point I was trying to raise.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Alexander Kuzmenkov
Date:
Subject: Re: [HACKERS] PoC: full merge join on comparison clause
Next
From: Peter Eisentraut
Date:
Subject: Re: [HACKERS] obsolete code in pg_upgrade