| From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
|---|---|
| To: | Etsuro Fujita <fujita(dot)etsuro(at)lab(dot)ntt(dot)co(dot)jp> |
| Cc: | Rushabh Lathia <rushabh(dot)lathia(at)gmail(dot)com>, Thom Brown <thom(at)linux(dot)com>, Stephen Frost <sfrost(at)snowman(dot)net>, Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Shigeru Hanada <shigeru(dot)hanada(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Optimization for updating foreign tables in Postgres FDW |
| Date: | 2016-02-12 12:46:23 |
| Message-ID: | CA+TgmobKLKO0TE7hzmNKpJEA9q8efUQ3cnUZ5TYTKtLJSVyKEw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Fri, Feb 12, 2016 at 7:19 AM, Etsuro Fujita
<fujita(dot)etsuro(at)lab(dot)ntt(dot)co(dot)jp> wrote:
> I think that displaying target lists would be confusing for users. Here is
> an example:
>
> EXPLAIN (verbose, costs off)
> DELETE FROM rem1; -- can be pushed down
> QUERY PLAN
> ---------------------------------------------
> Delete on public.rem1
> -> Foreign Delete on public.rem1
> Output: ctid
> Remote SQL: DELETE FROM public.loc1
> (4 rows)
>
> Should we output the "Output" line?
I see your point, but what if there's a RETURNING clause?
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2016-02-12 12:59:06 | Re: GinPageIs* don't actually return a boolean |
| Previous Message | Robert Haas | 2016-02-12 12:43:50 | Re: Re: [COMMITTERS] pgsql: Add some isolation tests for deadlock detection and resolution. |