Large table updates

From: Chris Pizzo <chris(at)artinside(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Large table updates
Date: 2003-04-03 18:18:29
Message-ID: 5.2.0.9.1.20030403131153.00a7da70@216.162.64.162
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi all,
I have a table with 3mill records of which 500K need updating. If I run:
update fmstitm set dist = 't' where fmstitm.fitem = dist_its.fitem

does it update the entire table or one record at a time...

in other words I run
select count(*) from fmstitm where dist = 't';

as the update is running and i get o results. Is this normal? The update
is taking a long time 1+ hours so far.
I just want to check that something might be wrong without any results
returned by the count(*) query.

-Chris

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Don Patou 2003-04-03 18:24:40 question about auto increment like
Previous Message Josh Berkus 2003-04-03 16:45:06 Re: ERROR: More than one tuple returned by a subselect used as an expression.