On 1/13/2010 11:36 PM, Craig Ringer wrote:
> Robert Haas wrote:
>> I'm kind of surprised that there are disk I/O subsystems that are so
>> bad that a single thread doing non-stop I/O can take down the whole
>> server. Is that normal?
>> Does it happen on non-Windows operating
> Yes. My 3ware 8500-8 on a Debian Sarge box was so awful that launching a
> terminal would go from a 1/4 second operation to a 5 minute operation
> under heavy write load by one writer. I landed up having to modify the
> driver to partially mitigate the issue, but a single user on the
> terminal server performing any sort of heavy writing would still
> absolutely nuke performance.
On a side note, on linux, would using the deadline scheduler resolve that?
In response to
pgsql-performance by date
|Next:||From: tom||Date: 2010-01-14 14:58:44|
|Subject: Slow "Select count(*) ..." query on table with 60 Mio. rows|
|Previous:||From: Ivan Voras||Date: 2010-01-14 14:49:16|
|Subject: Re: Inserting 8MB bytea: just 25% of disk perf used?|