| 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: | Whole Thread | Raw Message | 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
| 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. |