X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id A5066D1D07E for ; Thu, 15 Apr 2004 18:06:42 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 08795-10 for ; Thu, 15 Apr 2004 18:06:46 -0300 (ADT) Received: from MP-NY01.horizonk.com (mp-ny01.horizonk.com [208.51.57.221]) by svr1.postgresql.org (Postfix) with SMTP id 5B070D1CCDA for ; Thu, 15 Apr 2004 18:06:39 -0300 (ADT) Received: from hklog ([192.168.69.176]) by hk-nysrv01.horizonk.com with Microsoft SMTPSVC(5.0.2195.6713); Thu, 15 Apr 2004 17:06:44 -0400 Subject: Update is very slow on a bigger table From: Dimitar Georgievski To: pgsql-sql@postgresql.org In-Reply-To: <200404151507.RAA03297@rodos> References: <200404151507.RAA03297@rodos> Content-Type: text/plain Organization: Horizon Knwoledge Message-Id: <1082063227.5415.217.camel@hklog> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.4 Date: Thu, 15 Apr 2004 17:07:07 -0400 Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 15 Apr 2004 21:06:44.0410 (UTC) FILETIME=[8E7A59A0:01C4232D] X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/144 X-Sequence-Number: 17519 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? thanks, dimitar