Uroš Gruber wrote:
Hi!
I have table with row named rank and some other rows. I have about
900.000 rows in table and I need to update
all rows with the same value of rank, so I run update table set rank = 1;
The only problem is speed. I'm waiting about 30 minutes and it's still
running.
My system is pg8.1 with one SATA HD and P43GHz
And is your disk very busy?
Has this table been updated a lot without being vacuumed regularly?
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly