Postgres Pro
Downloads
Home   >   mailing lists

Re: System hangs when Insert/Update - Mailing list pgsql-admin

From Tom Lane
Subject Re: System hangs when Insert/Update
Date
Msg-id 11048.991461766@sss.pgh.pa.us
Whole thread Raw
In response to System hangs when Insert/Update  (Lee Kwok Shing <kslee@graduate.hku.hk>)
List pgsql-admin
Tree view 
Lee Kwok Shing <kslee@graduate.hku.hk> writes:
> for something since the following statements are execution repeatedly
>     select (0, NULL, NULL, .....

Sounds like the backends are waiting for a spinlock.  Could you
provide a debugger stack trace?

            regards, tom lane

pgsql-admin by date:

Previous
From: Lee Kwok Shing
Date:
Subject: System hangs when Insert/Update
Next
From: Tom Lane
Date:
Subject: Re: System hangs when Insert/Update