>>> On Sat, Sep 1, 2007 at 12:29 PM, in message
<20070901102947(dot)0c0a50a3(at)boffin(dot)xmtservices(dot)net>, Shawn
<postgres(at)xmtservices(dot)net> 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