Hi Tom, Thanks for yout information. There should be no clients disconnect in the middle of a transaction since the problem happens even if there is only one update. More have capture some traces, the query seems hanged after the phase ProcessQuery and before CommitTransactionCommand The query plan and the parser outputs process phase has been passed. So it seems that the query is stuck at committing the transaction... It is even strange that after I killing the process and issue the same query again, it success !!! Thanks again ! Regards, Lee Kwok Shing Tom Lane wrote: > Lee Kwok Shing <[EMAIL PROTECTED]> writes: > > I am using PostgreSQL 7.0.2 on RH 6.2 > > The DB works smoothly in the past 8 months but until recently, the > > system would hang when doing insert or update statements. > > Second thought on this: do you have any clients that might disconnect in > the middle of a transaction? If so, update to 7.0.3 (or later). > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] -- Lee Kwok Shing (***) http://www.geocities.com/lkslee.geo
begin:vcard n:Lee;Kwok Shing x-mozilla-html:TRUE url:http://www.geocities.com/lkslee.geo adr:;;;;;; version:2.1 email;internet:[EMAIL PROTECTED] fn:Kwok Shing Lee end:vcard
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
