Re: [PERFORM] Performance of Postgresql Foreign Data Wrapper

2015-01-30 Thread Jim Nasby
On 1/14/15 10:48 AM, Cassiano, Marco wrote: Both query were issued repeatedly to get rid of disk access and database connection overhead time. Activating duration and statement logging on the remote server I can see that the query issued through the fdw from the LOCAL SERVER is actually perform

[PERFORM] Performance of Postgresql Foreign Data Wrapper

2015-01-14 Thread Cassiano, Marco
Hello, If possible, I would need your help/suggestions for this problem : I'm experiencing a serious performance problem using postgresql foreign data wrapper. In particular, a simple query performed via fdw lasts 80 times more than the same query performed directly on the local server. Here a