Re: [HACKERS] [idea] more aggressive join pushdown on postgres_fdw

2015-06-08 Thread Robert Haas
On Fri, Jun 5, 2015 at 5:51 AM, Shigeru HANADA wrote: > 2015/06/05 6:43、Robert Haas のメール: >> On Sat, May 30, 2015 at 9:03 PM, Kouhei Kaigai wrote: >> Neat idea. This ties into something I've thought about and mentioned >> before: what if the innerrel is local, but there's a replicated copy >> o

Re: [HACKERS] [idea] more aggressive join pushdown on postgres_fdw

2015-06-05 Thread Shigeru HANADA
2015/06/05 6:43、Robert Haas のメール: > On Sat, May 30, 2015 at 9:03 PM, Kouhei Kaigai wrote: > Neat idea. This ties into something I've thought about and mentioned > before: what if the innerrel is local, but there's a replicated copy > on the remote server? Perhaps both cases are worth thinking

Re: [HACKERS] [idea] more aggressive join pushdown on postgres_fdw

2015-06-04 Thread Kouhei Kaigai
> On Thu, Jun 4, 2015 at 9:40 PM, Kouhei Kaigai wrote: > >> Neat idea. This ties into something I've thought about and mentioned > >> before: what if the innerrel is local, but there's a replicated copy > >> on the remote server? Perhaps both cases are worth thinking about at > >> some point. >

Re: [HACKERS] [idea] more aggressive join pushdown on postgres_fdw

2015-06-04 Thread Robert Haas
On Thu, Jun 4, 2015 at 9:40 PM, Kouhei Kaigai wrote: >> Neat idea. This ties into something I've thought about and mentioned >> before: what if the innerrel is local, but there's a replicated copy >> on the remote server? Perhaps both cases are worth thinking about at >> some point. >> > I think

Re: [HACKERS] [idea] more aggressive join pushdown on postgres_fdw

2015-06-04 Thread Kouhei Kaigai
> On Sat, May 30, 2015 at 9:03 PM, Kouhei Kaigai wrote: > > Yesterday, JPUG held an unconference event at Tokyo, and > > Hanada-san had a talk about join-pushdown feature of > > postgres_fdw. > > At this talk, someone proposed an interesting idea to > > make join pushdown more aggressive/effective

Re: [HACKERS] [idea] more aggressive join pushdown on postgres_fdw

2015-06-04 Thread Robert Haas
On Sat, May 30, 2015 at 9:03 PM, Kouhei Kaigai wrote: > Yesterday, JPUG held an unconference event at Tokyo, and > Hanada-san had a talk about join-pushdown feature of > postgres_fdw. > At this talk, someone proposed an interesting idea to > make join pushdown more aggressive/effective. > Let me s

[HACKERS] [idea] more aggressive join pushdown on postgres_fdw

2015-05-30 Thread Kouhei Kaigai
Hi, Yesterday, JPUG held an unconference event at Tokyo, and Hanada-san had a talk about join-pushdown feature of postgres_fdw. At this talk, someone proposed an interesting idea to make join pushdown more aggressive/effective. Let me share it with pgsql-hackers. He said, we may have a workload t