Re: System hangs when Insert/Update

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Lee Kwok Shing <kslee(at)graduate(dot)hku(dot)hk>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: System hangs when Insert/Update
Date: 2001-06-02 06:02:46
Message-ID: 11048.991461766@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Lee Kwok Shing <kslee(at)graduate(dot)hku(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2001-06-02 14:01:54 Re: System hangs when Insert/Update
Previous Message Lee Kwok Shing 2001-06-02 03:48:32 System hangs when Insert/Update