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

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 (view raw or flat)
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

pgsql-performance by date

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

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