Re: WAL bandwidth

On 05/22/2014 12:04 PM, John R Pierce wrote:
>
> On 5/22/2014 11:46 AM, Joshua D. Drake wrote:
>>
>> This does not appear the domain of PostgreSQL as much as the domain of
>> your OS and network layer.
>
> I think he's asking for a throttle on create index, so OTHER WAL
> activity would proceed at full speed, but the CREATE INDEX would somehow
> constrain itself to not generating more than N blocks/second
>

Yeah I was a bit obtuse in my answer. I didn't meant to be. IMO, the
problem is that he doesn't have enough Network IO. We don't want to
throttle PostgreSQL.

JD


--
Command Prompt, Inc. - http://www.commandprompt.com/  509-416-6579
PostgreSQL Support, Training, Professional Services and Development
High Availability, Oracle Conversion, Postgres-XC, @cmdpromptinc
Political Correctness is for cowards.