Search Postgresql Archives

Re: WAL bandwidth

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




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.



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux