Re: WAL bandwidth

On 05/22/2014 11:25 AM, Torsten Förtsch wrote:
>
> Hi,
>
> time and again I need to build indexes. If they are big, that generates
> a lot of WAL data that needs to be replicated to streaming replication
> slaves. Usually these slaves don't lag behind noticeably. So, the
> application often reads from them. Well, unless I build indexes and,
> thus, create a huge amount of WAL in a short period of time.
>
> What I'd like to have is something where I can set the max. bandwidth
> with which the index generating backend may generate WAL data. I seem to
> remember to have seen a discussion about something similar but can't
> recall where.
>
> Is there anything I can do about that problem in 9.3 or 9.4?
>
> I already have a function that waits for the streaming slaves to catch
> up. But that mitigates the problem only at a very crude level. I'd like
> to be able to set that bandwidth to, say, 10mbit/sec. Then I can be sure
> that all my replicas are fine. How long the index creation takes, does
> not matter.

This does not appear the domain of PostgreSQL as much as the domain of
your OS and network layer.

Sincerely,

JD

>
> Thanks,
> Torsten
>
>
>

--
Command Prompt, Inc. - http://www.commandprompt.com/ 509-416-6579
PostgreSQL Support, Training, Professional Services and Development
High Availability, Oracle Conversion, Postgres-XC, @cmdpromptinc
Political Correctness is for cowards.