Re: Long-running query blocks all other queries - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Long-running query blocks all other queries
Date
Msg-id dcc563d10903190805q360a9420mda472cb4aef66a0d@mail.gmail.com
Whole thread Raw
In response to Long-running query blocks all other queries  ("Anton V. Belyaev" <anton.belyaev@gmail.com>)
List 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 by date:

Previous
From: Bill Moran
Date:
Subject: Re: Long-running query blocks all other queries
Next
From: "Marcelo Giovane"
Date:
Subject: Comando USE