[GENERAL] Throttling Streamming Replication

2013-01-25 Thread Rodrigo Pereira da Silva
Hi Guys, We are having a problem with our infrastructure provider because the network traffic between master and slave server is reaching more than 30k packages per second(SLA says 20k/second). Is there any way to throttle the streamming replication? I meant, any parameter that I set the max

Re: [GENERAL] Throttling Streamming Replication

2013-01-25 Thread Magnus Hagander
On Fri, Jan 25, 2013 at 1:59 PM, Rodrigo Pereira da Silva rodr...@paripassu.com.br wrote: Hi Guys, We are having a problem with our infrastructure provider because the network traffic between master and slave server is reaching more than 30k packages per second(SLA says 20k/second). Is there

Re: [GENERAL] Throttling Streamming Replication

2013-01-25 Thread Cliff de Carteret
Can you not change your method of streaming replication. What is your archive command, are you using rsync as you can control the bandwidth limit? We use: archive_command = 'test ! -f /opt/postgres/remote_pgsql/wal_archive/%f rsync -az %p /opt/postgres/remote_pgsql/wal_archive/%f' According to

Re: [GENERAL] Throttling Streamming Replication

2013-01-25 Thread Rodrigo Pereira da Silva
That's a good idea, but we are using windows copy command, not sure if it has something similar. Anyway, we just talked to infrastructure provider and they figured out it was a problem with their monitoring system, so we are not reaching 30k packages actually. Thanks a lot for the replies,

Re: [GENERAL] Throttling Streamming Replication

2013-01-25 Thread Scott Marlowe
On Fri, Jan 25, 2013 at 5:59 AM, Rodrigo Pereira da Silva rodr...@paripassu.com.br wrote: Hi Guys, We are having a problem with our infrastructure provider because the network traffic between master and slave server is reaching more than 30k packages per second(SLA says 20k/second). Is there

Re: [GENERAL] Throttling Streamming Replication

2013-01-25 Thread Gavan Schneider
On Friday, January 25, 2013 at 23:59, Rodrigo Pereira da Silva wrote: We are having a problem with our infrastructure provider because the network traffic between master and slave server is reaching more than 30k packages per second(SLA says 20k/second). I note the later post where the