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