The account ID will be occupied by deleted/ suspended account?

Were IDs be occupied by these accounts forever? Can I just remove these account records in PostgreSQL?

Assuming by “account ID” you mean username, then yes, usernames of suspended accounts are kept forever, mostly to avoid issues with remote instances possibly confusing the old and new accounts, and to keep a trace of reports etc.

The cleanest way to free up those usernames may be something like typing the following in RAILS_ENV=production bundle exec rails c:

Account.where(domain: nil, username: ['suspended_user1', 'suspended_user2']).destroy_all
3 Likes

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.