>>> On Sat, Sep 1, 2007 at 12:29 PM, in message
<[EMAIL PROTECTED]>, Shawn
<[EMAIL PROTECTED]> wrote: 
> update shawns_data set alias = null;
> Even after VACUUM this simple line takes 35 sec to complete.
 
Would any rows already have a null alias when you run this?
 
If so, try adding 'where alias is not null' to the query.
 
-Kevin
 



---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply via email to