| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | John R Pierce <pierce(at)hogranch(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: WAL bandwidth |
| Date: | 2014-05-22 19:17:12 |
| Message-ID: | 537E4D38.7000403@commandprompt.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Torsten Förtsch | 2014-05-22 19:31:39 | Re: WAL bandwidth |
| Previous Message | Jeff Janes | 2014-05-22 19:05:35 | Re: WAL bandwidth |