>>> On Sat, Sep 1, 2007 at 12:29 PM, in message <20070901102947.0c0a50a3@xxxxxxxxxxxxxxxxxxxxxx>, Shawn <postgres@xxxxxxxxxxxxxxx> 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
