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 14:01:54
Message-ID: 11543.991490514@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:
> 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Stefan Huber 2001-06-02 15:33:46 Re: Re: Database over multiple drives
Previous Message Tom Lane 2001-06-02 06:02:46 Re: System hangs when Insert/Update