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-08 12:11:22
Message-ID: CAFjFpReFWp3tsh7zDhBmQiCGzb_ur6zF4YO8F-VBseonovn5dQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Jeevan Chalke pointed out that there was another conflict. This was because
of commit 392998bc58a985ea978c94c23594eb214d04c744. Here's patch rebased.

On Sun, Feb 7, 2016 at 5:41 PM, Ashutosh Bapat <
ashutosh(dot)bapat(at)enterprisedb(dot)com> wrote:

>
>
> On Sun, Feb 7, 2016 at 9:09 AM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
>
>> On Sat, Feb 6, 2016 at 12:46 AM, Ashutosh Bapat
>> <ashutosh(dot)bapat(at)enterprisedb(dot)com> wrote:
>> > 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.
>>
>> The thing to do here is leave a blank line between each one. You can
>> also put a line of dashes before and after the comment (see many
>> examples elsewhere in the source tree) to force pgindent to leave that
>> section completely untouched, but I think that this sort of list looks
>> better with blank lines anyway, so I'd go for that solution.
>>
>> > 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?
>>
>> Same idea here.
>>
>>
> Thanks a lot for the trick. Attached patch with the comments fixed.
>
> --
> Best Wishes,
> Ashutosh Bapat
> EnterpriseDB Corporation
> The Postgres Database Company
>

--
Best Wishes,
Ashutosh Bapat
EnterpriseDB Corporation
The Postgres Database Company

Attachment Content-Type Size
pg_join_pd_v10.patch application/x-download 164.7 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2016-02-08 12:17:14 Re: proposal: schema PL session variables
Previous Message Marko Tiikkaja 2016-02-08 12:03:16 Re: proposal: schema PL session variables