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

From Tom Lane
Subject Re: System hangs when Insert/Update
Date
Msg-id 11543.991490514@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
Lee Kwok Shing <kslee@graduate.hku.hk> 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

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: System hangs when Insert/Update
Next
From: Stefan Huber
Date:
Subject: Re: Re: Database over multiple drives