In what cases is it desirable to separate data into separate databases?

Question

PostgreSQL

For example, is it advisable to take out users (Accounts -> Users) separately, and the forum (Forums -> Themes, Forums -> Posts) also separately?
Can eat what literature good on the organization of databases?

Answer 1

It is advisable if you want to divide geographically or organizationally - in terms of security, for example. In all other cases, it is not necessary. Postgres scales vertically in terms of load by spreading tables across independent storage devices using tablespaces.