It should. The schema is super simplistic because it's nostr and not Mastodon. Mastodon, Misskey has a ton of users and they all use Postgresql