Racism remains "a blight" on society, US President Barack Obama says, in the wake of the killing of nine African-Americans in a South Carolina church.