Re: [SQL] Update is very slow on a bigger table

2004-04-16 Thread Dimitar Georgievski
imitar On Thu, 2004-04-15 at 18:51, Tom Lane wrote: > Dimitar Georgievski <[EMAIL PROTECTED]> writes: > > the process under which the update is running reports among the usual > > process data "UPDATE waiting". > > I don't think the UPDATE is doing an

[SQL] Update is very slow on a bigger table

2004-04-15 Thread Dimitar Georgievski
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.