How private the chat is is defined by E2E client encryption. Dendrite + Postgres uses ~320MB of my home server memory with negligible CPU and that’s while joined to a few federated rooms.