Re: Backup throttling

Поиск
Список
Период
Сортировка
От Boszormenyi Zoltan
Тема Re: Backup throttling
Дата
Msg-id 521260D7.4080401@cybertec.at
обсуждение исходный текст
Ответ на Re: Backup throttling  (Andres Freund <andres@2ndquadrant.com>)
Ответы Re: Backup throttling  (Andres Freund <andres@2ndquadrant.com>)
Re: Backup throttling  (Heikki Linnakangas <hlinnakangas@vmware.com>)
Список pgsql-hackers
2013-08-19 19:20 keltezéssel, Andres Freund írta:
> Hi,
>
> On 2013-07-24 09:20:52 +0200, Antonin Houska wrote:
>> Hello,
>> the purpose of this patch is to limit impact of pg_backup on running server.
>> Feedback is appreciated.
> Based on a quick look it seems like you're throttling on the receiving
> side. Is that a good idea? Especially over longer latency links, TCP
> buffering will reduce the effect on the sender side considerably.
>
> Greetings,
>
> Andres Freund

Throttling on the sender side requires extending the syntax of
BASE_BACKUP and maybe START_REPLICATION so both can be
throttled but throttling is still initiated by the receiver side.

Maybe throttling the walsender is not a good idea, it can lead
to DoS via disk space shortage.

Best regards,
Zoltán Böszörményi

-- 
----------------------------------
Zoltán Böszörményi
Cybertec Schönig & Schönig GmbH
Gröhrmühlgasse 26
A-2700 Wiener Neustadt, Austria
Web: http://www.postgresql-support.de     http://www.postgresql.at/




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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: danger of stats_temp_directory = /dev/shm
Следующее
От: Boszormenyi Zoltan
Дата:
Сообщение: Re: UNNEST with multiple args, and TABLE with multiple funcs