Re: commit so slow program looks frozen

From: "Carlo Stonebanks" <stonec(dot)register(at)sympatico(dot)ca>
To: "'Brian Hurt'" <bhurt(at)janestcapital(dot)com>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: commit so slow program looks frozen
Date: 2006-10-25 20:32:16
Message-ID: 036901c6f874$a907e700$6f05a8c0@Mars
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

>> I have a question for you: did you have a long running query keeping open
a transaction? I've just noticed the same problem here, but things cleaned
up immediately when I aborted the long-running transaction.

No, the only processes are from those in the import applications themselves:
short transactions never lasting more than a fraction of a second.

Carlo

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Mark Lonsdale 2006-10-25 20:47:50 Configuration Issue ?
Previous Message Brian Hurt 2006-10-25 20:18:51 Re: commit so slow program looks frozen