On Thu, Sep 24, 2009 at 9:27 AM, <jesper(at)krogh(dot)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