It also creates multiple classes of problems. There are known issues with PostgreSQL's handling of databases containing tens of thousands of tables. (you will need a disproportionate amount of memory to handle that use case on a busy db server).
Using a single database with tenant isolation by a discriminator key (preferably enforced by row level security) is a lot more efficient.