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