Re: System hangs when Insert/Update

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