Skip site navigation (1) Skip section navigation (2)

Speed while runnning large transactions.

From: jesper(at)krogh(dot)cc
To: pgsql-performance(at)postgresql(dot)org
Subject: Speed while runnning large transactions.
Date: 2009-09-24 08:27:46
Message-ID: 213dfa8ce7aa9620dcbabf9578c0eb20.squirrel@shrek.krogh.cc (view raw or flat)
Thread:
Lists: pgsql-performance
Hi.

I have a transaction running at the database for around 20 hours .. still
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 are
also very low.

What can I do to make the system handle other queries better?

PG: 8.2

-- 
Jesper


Responses

pgsql-performance by date

Next:From: Claus GuttesenDate: 2009-09-24 08:41:44
Subject: Re: Speed while runnning large transactions.
Previous:From: Hell, RobertDate: 2009-09-24 06:41:22
Subject: Re: Different query plans for the same query

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group