Re: postgres_fdw join pushdown (was Re: Custom/Foreign-Join-APIs)

From: Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Thom Brown <thom(at)linux(dot)com>, Etsuro Fujita <fujita(dot)etsuro(at)lab(dot)ntt(dot)co(dot)jp>, "pgsql-hackers(at)postgreSQL(dot)org" <pgsql-hackers(at)postgresql(dot)org>, Kouhei Kaigai <kaigai(at)ak(dot)jp(dot)nec(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Shigeru Hanada <shigeru(dot)hanada(at)gmail(dot)com>
Subject: Re: postgres_fdw join pushdown (was Re: Custom/Foreign-Join-APIs)
Date: 2016-02-06 05:46:27
Message-ID: CAFjFpRcgJ=+mkL-Q+kY5UCi-Dv_MDBp+iOEhYrRwoq4gR5DvRQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sat, Feb 6, 2016 at 2:00 AM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:

> On Fri, Feb 5, 2016 at 4:23 AM, Ashutosh Bapat
> <ashutosh(dot)bapat(at)enterprisedb(dot)com> wrote:
> > I have corrected this in this set of patches. Also, I have included the
> > change to build the join relation description while constructing fpinfo
> in
> > the main patch since that avoids repeated building of the same at a small
> > cost of constructing relation name for base relations, which goes waste
> if
> > that relation is not going to be part of any pushable join tree.
> >
> > Ran pgindent as well.
>
> pg_fdw_join_v9.patch does not aplpy.
>

Here it is rebased. Thanks for the pgindent run and committing core
changes. I have to manage only one patch now :)

pgindent is giving trouble with following two comments

2213 /* Run time cost includes:
2214 * 1. Run time cost (total_cost - startup_cost) of
relations being
2215 * joined
2216 * 2. Run time cost of applying join clauses on the cross
product of
2217 * the joining relations.
2218 * 3. Run time cost of applying pushed down other clauses
on the
2219 * result of join
2220 * 4. Run time cost of applying nonpushable other clauses
locally
2221 * on the result fetched from the foreign server.
2222 */

which I want itemized with each item starting on separate line. pgindent
just bunches everything together.

1159 /*
1160 * For a join relation FROM clause entry is deparsed as
1161 * ((outer relation) <join type> (inner relation) ON
(joinclauses)
1162 */
where I want the second line as a separate line, but pgindent puts those
two line together breaking the continuity of second line content.

How do I make pgindent respect those changes as they are?

Attachment Content-Type Size
pg_join_pd_v10.patch text/plain 164.7 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Stephen Frost 2016-02-06 06:11:25 Re: Explanation for bug #13908: hash joins are badly broken
Previous Message Noah Misch 2016-02-06 04:52:41 Re: LLVM Address Sanitizer (ASAN) and valgrind support