Re: WAL Rate Limiting

Поиск
Список
Период
Сортировка
От Craig Ringer
Тема Re: WAL Rate Limiting
Дата
Msg-id 52D605F4.4010706@2ndquadrant.com
обсуждение исходный текст
Ответ на WAL Rate Limiting  (Simon Riggs <simon@2ndQuadrant.com>)
Список pgsql-hackers
On 01/15/2014 10:20 AM, Simon Riggs wrote:
> (discuss: do we need another parameter to specify "cost"? Currently
> patch uses "sleep every 64kB of WAL")

It might be nicer to express this as "up to n MB of WAL per second", but
otherwise seems reasonable, and it's easy enough to convert WAL MB/s
into a delay by hand.

Initial tests of this show that it does limit index creation rates as
expected, while continuing to allow WAL generation at normal rates for
other concurrent work.


-- Craig Ringer                   http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training & Services



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

Предыдущее
От: Jim Nasby
Дата:
Сообщение: Re: Linux kernel impact on PostgreSQL performance
Следующее
От: Jim Nasby
Дата:
Сообщение: Re: [Lsf-pc] Linux kernel impact on PostgreSQL performance