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