Re: many row updates

[Richard Huxton <dev@xxxxxxxxxxxx>]

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