pg.ddx.io pgsql-performance@postgresql.org mailing list archivehelp / color / mirror / Atom feed
pg9 replication over WAN ? 2+ messages / 2 participants [nested] [flat]
* pg9 replication over WAN ? @ 2011-10-05 21:53 Ben Ciceron <ben@triggit.com> 0 siblings, 1 reply; 2+ messages in thread From: Ben Ciceron @ 2011-10-05 21:53 UTC (permalink / raw) To: pgsql-performance 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- ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: pg9 replication over WAN ? @ 2011-10-07 03:22 mark <dvlhntr@gmail.com> parent: Ben Ciceron <ben@triggit.com> 0 siblings, 0 replies; 2+ messages in thread From: mark @ 2011-10-07 03:22 UTC (permalink / raw) To: 'Ben Ciceron' <ben@triggit.com>; +Cc: pgsql-performance > -----Original Message----- > From: pgsql-performance-owner@postgresql.org [mailto:pgsql-performance- > owner@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- > performance@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2011-10-07 03:22 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2011-10-05 21:53 pg9 replication over WAN ? Ben Ciceron <ben@triggit.com> 2011-10-07 03:22 ` mark <dvlhntr@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox