Throttling Streamming Replication

From: Rodrigo Pereira da Silva <rodrigo(at)paripassu(dot)com(dot)br>
To: pgsql-general(at)postgresql(dot)org
Subject: Throttling Streamming Replication
Date: 2013-01-25 12:59:16
Message-ID: 510281A4.6070705@paripassu.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 number of megabytes sent to standby server
per second?
I didn't have any luck looking at the postgresql streamming replication
documentation. There is the wal_sender_delay, but I suppose that if I
set more than 1 second, it could accumulate a bunch of wal files and
send it at once. So, it wouldn't work.

Thanks in advance,

--
Rodrigo Pereira da Silva
rodrigo(at)paripassu(dot)com(dot)br
http://www.paripassu.com.br
Rua Coronel Luis Caldeira, nº 67, Bloco 1, Sala 3A
88034-110 • Florianópolis • SC
Tel. (48) 3207-5755

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Magnus Hagander 2013-01-25 12:59:44 Re: Throttling Streamming Replication
Previous Message James Cowell 2013-01-25 11:57:57 Re: seeking SQL book recommendation