WAL bandwidth

From: Torsten Förtsch <torsten(dot)foertsch(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: WAL bandwidth
Date: 2014-05-22 18:25:09
Message-ID: 537E4105.8090904@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Thanks,
Torsten

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2014-05-22 18:28:30 Re: Do foreign key triggers get ran even if the key's value doesn't change?
Previous Message Joe Van Dyk 2014-05-22 17:56:37 Re: Do foreign key triggers get ran even if the key's value doesn't change?