Data quantity issues when querying data from SQL Server using a PostgreSQL foreign data wrapper

sql-server postgresql ubuntu-12.04 freetds

Try with 'initial block size' parameter in freetds.conf, I've set this in 5120 and sometimes even bigger.Seehttp://www.freetds.org/userguide/seemtooslow.htm