> On Thu, Sep 24, 2009 at 9:27 AM, <jesper(at)krogh(dot)cc> wrote:
>> I have a transaction running at the database for around 20 hours ..
>> isn't done. But during the last hours it has come to the point where it
>> really hurts performance of "other queries".
>> Given pg_stat_activity output there seems to be no locks interfering but
>> the overall cpu-usage of all queries continue to rise. iowait numbers
>> also very low.
>> What can I do to make the system handle other queries better?
>> show us explain from the query(s).
> use select * from pg_stat_activity to find out the state query is in, and
> perhaps which one of the queries it really is.
I'm actively monitoring pg_stat_activity for potential problems but the
thread is spending most of the time in the application side. The
transaction is holding a large set of inserts/update and delete for the
In response to
pgsql-performance by date
|Next:||From: Jared Beck||Date: 2009-09-24 12:22:52|
|Subject: Re: Slow query after upgrade to 8.4|
|Previous:||From: jesper||Date: 2009-09-24 11:35:48|
|Subject: Re: Speed while runnning large transactions.|