From: CoL <col@mportal.hu>
To: pgsql-sql@postgresql.org
Subject: Re: Update is very slow on a bigger table
Date: Fri, 16 Apr 2004 00:53:53 +0200
Message-ID: <c5n3oe$150s$1@news.hub.org> (raw)
In-Reply-To: <1082063227.5415.217.camel@hklog>
References: <200404151507.RAA03297@rodos>
<1082063227.5415.217.camel@hklog>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: col@mportal.hu
Subject: Re: Update is very slow on a bigger table
In-Reply-To: <c5n3oe$150s$1@news.hub.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox