Re: commit so slow program looks frozen - Mailing list pgsql-performance

From Carlo Stonebanks
Subject Re: commit so slow program looks frozen
Date
Msg-id 036901c6f874$a907e700$6f05a8c0@Mars
Whole thread Raw
In response to commit so slow program looks frozen  ("Carlo Stonebanks" <stonec.register@sympatico.ca>)
Responses Re: commit so slow program looks frozen  ("Jim C. Nasby" <jim@nasby.net>)
List 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

pgsql-performance by date:

Previous
From: "Luke Lonergan"
Date:
Subject: Re: Best COPY Performance
Next
From: "Mark Lonsdale"
Date:
Subject: Configuration Issue ?