Re: Long-running query blocks all other queries

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Long-running query blocks all other queries
Дата
Msg-id dcc563d10903190805q360a9420mda472cb4aef66a0d@mail.gmail.com
обсуждение исходный текст
Ответ на Long-running query blocks all other queries  ("Anton V. Belyaev" <anton.belyaev@gmail.com>)
Список pgsql-general
On Thu, Mar 19, 2009 at 8:42 AM, Anton V. Belyaev
<anton.belyaev@gmail.com> wrote:

> I have 4-cored machine, so I expected the query to be able to run for
> a long time without performance degrade for application.

As Bill mentioned, this won't help a bit if you've got a slow / dodgy
/ overloaded IO subsystem.  What does vmstat 1 60 have to say about
the situation when the queries are running?

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

Предыдущее
От: Bill Moran
Дата:
Сообщение: Re: Long-running query blocks all other queries
Следующее
От: "Marcelo Giovane"
Дата:
Сообщение: Comando USE