Any hints on how to improve WAN replication performance? It seems that replicating to Postgres involves waiting on a lot of round-trips. A nearby server replicates fairly quick (few thousand row/sec), whereas on 30ms away goes very, very slowly. (5KB/sec throughput, only a few rows/sec.) Same hardware, so it seems to indicate network related problems. SQL Server Activity Monitor shows a lot of waits on Network I/O.
I tried creating the subscription with "SQLSERVER=2008;BULK_METHOD=COPY;BULK_INSERT=1000;" in the provider string, but it didn't make any difference. I thought this was supposed to absorb consecutive INSERTs and somehow make it more efficient, automagically?
Is this a limitation from SQL Server that's impossible to workaround, or what are my options? I don't mind if individual transactions take a long time (that is, if I do 1000 separate inserts, I don't care too much if it's slow), but bulk loads (either initial, or when I do a bulk copy into a table), should go reasonably quick... right?
I'm using SQL Server 2012, Postgres 9.1.3, and PGNP 1.3.