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

Re: Speed while runnning large transactions.

From: Claus Guttesen <kometen(at)gmail(dot)com>
To: jesper(at)krogh(dot)cc
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Speed while runnning large transactions.
Date: 2009-09-24 08:41:44
Message-ID: b41c75520909240141k4dba6089n7907930cfa535890@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
> 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?

Can you post the query? Do you 'vacuum analyze' on a regular basis?
You can also post your conf-file and post the last five lines from a
'vacuum analyze verbose'.

-- 
regards
Claus

When lenity and cruelty play for a kingdom,
the gentler gamester is the soonest winner.

Shakespeare

In response to

pgsql-performance by date

Next:From: Grzegorz JaśkiewiczDate: 2009-09-24 08:44:09
Subject: Re: Speed while runnning large transactions.
Previous:From: jesperDate: 2009-09-24 08:27:46
Subject: Speed while runnning large transactions.

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