It looks like the upgrade script does not add an index to the usrname field like it does for the various person-name fields. Perhaps we need a:
CREATE INDEX CONCURRENTLY actor_usr_usrname_unaccent_idx ON actor.usr (evergreen.unaccent_and_squash(usrname));
It looks like the upgrade script does not add an index to the usrname field like it does for the various person-name fields. Perhaps we need a:
CREATE INDEX CONCURRENTLY actor_usr_ usrname_ unaccent_ idx ON actor.usr (evergreen. unaccent_ and_squash( usrname) );