Re: a heavy duty operation on an "unused" table kills my server

Поиск
Список
Период
Сортировка
От Andy Colson
Тема Re: a heavy duty operation on an "unused" table kills my server
Дата
Msg-id 4B4F2F00.7070401@squeakycode.net
обсуждение исходный текст
Ответ на Re: a heavy duty operation on an "unused" table kills my server  (Craig Ringer <craig@postnewspapers.com.au>)
Ответы Re: a heavy duty operation on an "unused" table kills my server  (Greg Smith <greg@2ndquadrant.com>)
Список pgsql-performance
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?
>
> No.
>
>> Does it happen on non-Windows operating
>> systems?
>
> 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?

-Andy

В списке pgsql-performance по дате отправления:

Предыдущее
От: "fkater@googlemail.com"
Дата:
Сообщение: Inserting 8MB bytea: just 25% of disk perf used?
Следующее
От: Ivan Voras
Дата:
Сообщение: Re: Inserting 8MB bytea: just 25% of disk perf used?