2008/10/2 Knight, Doug <dknight at wsi.com>:
> I put together a quick test, copying one of my largest tables (around 1.7GB), from my staging system back to my workstation (not over the dedicated GB connection, but through our intranet). Without the binary qualifier on the COPY command it took 11 minutes and 33 seconds. With the binary option it took 2 minutes and 52 seconds. That's a significant savings in replication time, roughly 400% if my math is right. When I next test a slony copy, I'll compare results using the dedicated link to eliminate any random latencies on our intranet.

Wow, that's nice improvement.
the quick&dirty patch could be just to add WITH BINARY to both
copy-out and copy-in invocations in remote_worker.c
please share your success story afterwards :)


-- 
Filip Rembiałkowski