From: CoL <col@mportal.hu>
Subject: Re: Update is very slow on a bigger table
Date: Fri, 16 Apr 2004 00:53:53 +0200
Organization: Hub.Org Networking Services
Lines: 28
Message-ID: <c5n3oe$150s$1@news.hub.org>
References: <200404151507.RAA03297@rodos> <1082063227.5415.217.camel@hklog>
Reply-To: col@mportal.hu
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US;
	rv:1.7b) Gecko/20040316
In-Reply-To: <1082063227.5415.217.camel@hklog>
To: pgsql-sql@postgresql.org

hi,

Dimitar Georgievski wrote, On 4/15/2004 23:07:

> hi,
> 
> i'm running an update procedure on a table with approximately 100,000
> records. The problem is the procedure is running endlessly even when the
> update is very simple like in the following example:
> 
> update mytable
> set client_id = 1
> where mytable_id = 1
> 
> mytable_id is the primary key of mytable.
> 
> the process under which the update is running reports among the usual
> process data "UPDATE waiting".
> 
> I'm using PostgreSQL 7.3.4 on SuSE 9.0. From what I have seen it doesn't
> look like that the host computer has problem with the resources.
> 
> Any idea why is this happening?
could be, after you send some info: your table schema, your explain 
analyze result, triggers, or any other info. Any other transaction 
running again mytable while you try to update?

C.