On Thu, Sep 24, 2009 at 9:27 AM, <jes...@krogh.cc> wrote: > 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? > > 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.
-- GJ