Re: Unclear regression test for postgres_fdw

2017-12-01 Thread Robert Haas
On Fri, Dec 1, 2017 at 4:01 AM, Antonin Houska wrote: > I see no other problems here. Committed, thanks for the report and review. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company

Re: Unclear regression test for postgres_fdw

2017-12-01 Thread Antonin Houska
Jeevan Chalke wrote: > On Thu, Nov 30, 2017 at 3:44 PM, Jeevan Chalke > wrote: > > On Thu, Nov 30, 2017 at 1:36 AM, Antonin Houska wrote: > > The following test > > -- Input relation to aggregate push down hook is not safe to pushdown and > thus > -- the aggregate cannot be pushed down

Re: Unclear regression test for postgres_fdw

2017-11-30 Thread Jeevan Chalke
On Thu, Nov 30, 2017 at 3:44 PM, Jeevan Chalke < jeevan.cha...@enterprisedb.com> wrote: > > > On Thu, Nov 30, 2017 at 1:36 AM, Antonin Houska wrote: > >> The following test >> >> -- Input relation to aggregate push down hook is not safe to pushdown and >> thus >> -- the aggregate cannot be pushed

Re: Unclear regression test for postgres_fdw

2017-11-30 Thread Jeevan Chalke
On Thu, Nov 30, 2017 at 1:36 AM, Antonin Houska wrote: > The following test > > -- Input relation to aggregate push down hook is not safe to pushdown and > thus > -- the aggregate cannot be pushed down to foreign server. > explain (verbose, costs off) > select count(t1.c3) from ft1 t1, ft1 t2 whe