Re: Throttling Streamming Replication - Mailing list pgsql-general

From Cliff de Carteret
Subject Re: Throttling Streamming Replication
Date
Msg-id CAC+bnxkxeM_e8Mp7Th=fawdj6g67d+x6nnC592YTvzSbSG_VEg@mail.gmail.com
Whole thread Raw
In response to Re: Throttling Streamming Replication  (Magnus Hagander <magnus@hagander.net>)
Responses Re: Throttling Streamming Replication  (Rodrigo Pereira da Silva <rodrigo@paripassu.com.br>)
List pgsql-general
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 the link below you can add --bwlimit=1000 to the rsync arguments



On 25 January 2013 12:59, Magnus Hagander <magnus@hagander.net> wrote:
On Fri, Jan 25, 2013 at 1:59 PM, Rodrigo Pereira da Silva
<rodrigo@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 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.

No, there is no such parameter. You might be able to send it through
some proxy that slows it down, but there is no builtin support to do
that.

--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: Matthew Vernon
Date:
Subject: Logging successful SELECTS?
Next
From: Rodrigo Pereira da Silva
Date:
Subject: Re: Throttling Streamming Replication