Hi Oliver,
> currently idle except for the update statement. Any suggestions why
> it takes so long to update a couple million rows?
>
> update characters set last_update = null
Try to update only rows that not already null.
update characters set last_update = null where last_update is not null;
Jan