I have created foreign table with alot of data on the other side. If I select the entire table it takes around 4 mnutes to return the data.
If I create a view based on foreign table and execute a select that should return only one line, the server hangs. If I make the same select on the foreign table , it works very fast.
Does anyone have simmilar experience?
Hello,
I have created foreign table with alot of data on the other side. If I select the entire table it takes around 4 mnutes to return the data. If I create a view based on foreign table and execute a select that should return only one line, the server hangs. If I make the same select on the foreign table , it works very fast. Does anyone have simmilar experience?
Thanks, Regrds