Re: Adding and filling new column on big table

["Jonathan Blitz" <jb(at)anykey(dot)co(dot)il>]

> 
> 
> Could you do the updates in batches instead of trying to do them all at
> once?

Nope. Didn't think it would make any difference.
> 
> Have you done a vacuum full on this table ever?

Many times

> 
> What hardware?
> I have a dual CPU opteron with 4GB of RAM and 8 disks in RAID 10 (SATA).
> Doing an update on a 5 million record table took quite a while, but it did
> fininish. :-)

I am using a laptop :).
Pentium 4 (not 4M) with 1GB of memory - 2 MHZ

Must do it on  that since the program is aimed for use at home.

Jonathan

-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.7.4/351 - Release Date: 05/29/2006