Re: TRUNCATE on foreign table

From: Fujii Masao <masao(dot)fujii(at)oss(dot)nttdata(dot)com>
To: Kohei KaiGai <kaigai(at)heterodb(dot)com>, Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>
Cc: Kazutaka Onishi <onishi(at)heterodb(dot)com>, Zhihong Yu <zyu(at)yugabyte(dot)com>, Amit Langote <amitlangote09(at)gmail(dot)com>, Ibrar Ahmed <ibrar(dot)ahmad(at)gmail(dot)com>, PostgreSQL Developers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>
Subject: Re: TRUNCATE on foreign table
Date: 2021-04-13 15:00:14
Message-ID: 70310892-3572-f143-a692-e9aa4322a914@oss.nttdata.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 2021/04/13 23:25, Kohei KaiGai wrote:
> 2021年4月13日(火) 21:03 Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>:
>> Yeah, ONLY clause is not pushed to the remote server in case of SELECT
>> commands. This is also true for DELETE and UPDATE commands on foreign
>> tables.

This sounds reasonable reason why ONLY should be ignored in TRUNCATE on
foreign tables, for now. If there is the existing rule about how to treat
ONLY clause for foreign tables, basically TRUNCATE should follow that at this
stage. Maybe we can change the rule, but it's an item for v15 or later?

>> I'm not sure if it wasn't thought necessary or if there is an
>> issue to push it or I may be missing something here.

I could not find the past discussion about foreign tables and ONLY clause.
I guess that ONLY is ignored in SELECT on foreign tables case because ONLY
is interpreted outside the executor and it's not easy to change the executor
so that ONLY is passed to FDW. Maybe..

>> I think we can
>> start a separate thread to see other hackers' opinions on this.
>>
>> I'm not sure whether all the clauses that are possible for
>> SELECT/UPDATE/DELETE/INSERT with local tables are pushed to the remote
>> server by postgres_fdw.
>>
>> Well, now foreign TRUNCATE pushes the ONLY clause to the remote server
>> which is inconsistent when compared to SELECT/UPDATE/DELETE commands.
>> If we were to keep it consistent across all foreign commands that
>> ONLY clause is not pushed to remote server, then we can restrict for
>> TRUNCATE too and even if "TRUNCATE ONLY foreign_tbl" is specified,
>> just pass "TRUNCATE foreign_tbl" to remote server. Having said that, I
>> don't see any real problem in pushing the ONLY clause, at least in
>> case of TRUNCATE.
>>
> If ONLY-clause would be pushed down to the remote query of postgres_fdw,
> what does the foreign-table represent in the local system?
>
> In my understanding, a local foreign table by postgres_fdw is a
> representation of
> entire tree of the remote parent table and its children.

If so, I'm still wondering why CASCADE/RESTRICT (i.e., DropBehavior) needs to
be passed to FDW. IOW, if a foreign table is an abstraction of an external
data source, ISTM that postgres_fdw should always issue TRUNCATE with
CASCADE. Why do we need to allow RESTRICT to be specified for a foreign table
even though it's an abstraction of an external data source?

Regards,

--
Fujii Masao
Advanced Computing Technology Center
Research and Development Headquarters
NTT DATA CORPORATION

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Noah Misch 2021-04-13 15:00:34 Re: Extensions not dumped when --schema is used
Previous Message Craig Ringer 2021-04-13 14:48:02 Re: [PATCH] Identify LWLocks in tracepoints