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;
The below statement is now running for 18 hours on a table with ~8 Million
Rows, no triggers no fancy stuff. The database is otherwise performing very
well and the server is a development server that's currently idle except for
the update statement. Any suggestions why it takes so long to update a
