Re: Long-running query blocks all other queries

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: "Anton V(dot) Belyaev" <anton(dot)belyaev(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Long-running query blocks all other queries
Date: 2009-03-19 15:05:55
Message-ID: dcc563d10903190805q360a9420mda472cb4aef66a0d@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Mar 19, 2009 at 8:42 AM, Anton V. Belyaev
<anton(dot)belyaev(at)gmail(dot)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?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Marcelo Giovane 2009-03-19 15:23:18 Comando USE
Previous Message Bill Moran 2009-03-19 14:57:33 Re: Long-running query blocks all other queries