> -----Original Message----- > From: pgsql-performance-ow...@postgresql.org [mailto:pgsql-performance- > ow...@postgresql.org] On Behalf Of Ben Ciceron > Sent: Wednesday, October 05, 2011 3:53 PM > To: pgsql-performance@postgresql.org > Subject: [PERFORM] pg9 replication over WAN ? > > Hello, > > Has any performance or evaluation done for pg9.x streaming replication > over WAN ? > How adequate is the protocol to push WALs over long distance ? > Any best practice tuning wal_* for WAN ? > > Cheers, > Ben-
Works for us between the middle of the US and the UK. This on some databases that do a few gig of log files per day. I keep a large number of wal_keep_segments because I have the disk capacity for it and the initial rsync takes a while at ~2-4MB/s. You may find you need to tune the tcp-keep alive settings, but I am not sure if that was really a change in the setting or a fix to our load balancers that fixed an issue I was seeing. Overall I am extremely pleased with streaming replication + read only hot standby. -Mark > > -- > Sent via pgsql-performance mailing list (pgsql- > performa...@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
