Re: pg9 replication over WAN ?
От | mark |
---|---|
Тема | Re: pg9 replication over WAN ? |
Дата | |
Msg-id | 00bd01cc84a0$4f57a700$ee06f500$@com обсуждение исходный текст |
Ответ на | pg9 replication over WAN ? (Ben Ciceron <ben@triggit.com>) |
Список | 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
В списке pgsql-performance по дате отправления: