You are are something wrong.

Ditto works just fine with postgres and is a relay blaster.

Mastodon also  uses postgres to support way more users than nostr will ever see.