Re: WAL Rate Limiting - Mailing list pgsql-hackers

From Craig Ringer
Subject Re: WAL Rate Limiting
Date
Msg-id 52D605F4.4010706@2ndquadrant.com
Whole thread Raw
In response to WAL Rate Limiting  (Simon Riggs <simon@2ndQuadrant.com>)
List 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 by date:

Previous
From: Jim Nasby
Date:
Subject: Re: Linux kernel impact on PostgreSQL performance
Next
From: Jim Nasby
Date:
Subject: Re: [Lsf-pc] Linux kernel impact on PostgreSQL performance