On Sat, 17 Mar 2012 10:46:00 -0500, dennis jenkins
<dennis.jenkins.75@xxxxxxxxx> wrote:
Aleksey, a suggestion: The vast majority of the postgresql wire
protocol compresses well. If your WAN link is not already compressed,
construct a compressed SSH tunnel for the postgresql TCP port in the
WAN link. I've done this when rebuilding a 300GB database (via slony)
over a bandwidth-limited (2MB/s) VPN link and it cut the replication
resync time down significantly.
SSH with the HPN patchset[1] would help as well if it's higher latency or
if you're CPU limited as it can use multiple threads then. It works
wonderfully for me on a 35mbit link. If you have a lower sized link that
wouldn't benefit from the HPN patchset anyway it may be worth forcing
Blowfish instead of AES to keep the CPU load lower.
Hope that helps!
[1] http://www.psc.edu/networking/projects/hpn-ssh/
FYI, the HPN patchset is included the base OpenSSH of FreeBSD 9 now.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
