Re: how to slow down parts of Pg

Поиск
Список
Период
Сортировка
От Peter J. Holzer
Тема Re: how to slow down parts of Pg
Дата
Msg-id 20200422224332.GA4048@hjp.at
обсуждение исходный текст
Ответ на RE: how to slow down parts of Pg  (Kevin Brannen <KBrannen@efji.com>)
Ответы RE: how to slow down parts of Pg
Список pgsql-general
On 2020-04-21 21:16:57 +0000, Kevin Brannen wrote:
> From: Michael Loftis <mloftis@wgops.com>
> > drbdsetup allows you to control the sync rates.
>
> I was hoping not to have to do that, but the more I think about this I'm
> realizing that it won't hurt because the network cap is effectively limiting me
> anyway. :)

Alternatively you might consider traffic shaping. DRBD can only set a
fixed limit (because it knows only about its own traffic). Traffic
shaping can adjust the limit depending on other traffic (it can also
prioritize traffic, etc.). However, to be effective, it needs to run on
a router as close to the bottleneck as possible - typically that means
either the border router or the firewall. So it is something the
customer's network guy should set up.

        hp

--
   _  | Peter J. Holzer    | Story must make more sense than reality.
|_|_) |                    |
| |   | hjp@hjp.at         |    -- Charles Stross, "Creative writing
__/   | http://www.hjp.at/ |       challenge!"

Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: Ron
Дата:
Сообщение: Re: how to slow down parts of Pg
Следующее
От: "Peter J. Holzer"
Дата:
Сообщение: Re: How do work tercile, percentile & funcion percentile_cont() ?