Re: [PERFORM] 3000x Slower query when using Foreign Data Wrapper vs. local

2015-10-11 Thread Mohammad Habbab
:48 PM, desmodemone wrote: > > > 2015-10-11 12:10 GMT+02:00 Mohammad Habbab : > >> Awesome ! Thank you very much, that solved it :) . But, do you have any >> idea why this isn't enabled by default ? >> As a first time user for FDW I would assume that usage of remote

Re: [PERFORM] 3000x Slower query when using Foreign Data Wrapper vs. local

2015-10-11 Thread Mohammad Habbab
for its server, but only for that table. The default is false. > > > try it > > > Bye > > > 2015-10-11 10:05 GMT+02:00 Mohammad Habbab : > >> Hi there, >> >> If it's possible, I would really appreciate any hints or help on an issue >&g

[PERFORM] 3000x Slower query when using Foreign Data Wrapper vs. local

2015-10-11 Thread Mohammad Habbab
Hi there, If it's possible, I would really appreciate any hints or help on an issue I've been facing lately. I'm running two instance of Postgres locally: 9.4.4 (operational db) and 9.5beta1 (analytical db). I've already imported schema to analytical db and while doing the following query I find v