Re: WAL bandwidth - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: WAL bandwidth
Date
Msg-id 537E4D38.7000403@commandprompt.com
Whole thread Raw
In response to Re: WAL bandwidth  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
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.


pgsql-general by date:

Previous
From: Jeff Janes
Date:
Subject: Re: WAL bandwidth
Next
From: Torsten Förtsch
Date:
Subject: Re: WAL bandwidth