You could easily add a nostr relay to your akkoma vps.

It will only contain the posts from nostr clients that connect to that relay. It wont store all the posts from everywhere like fedi software