Schemas should be approached with extreme caution. They still suffer from the same issues as multiple databases, but now also you have to juggle search path and

Schemas should be approached with extreme caution. They still suffer from the same issues as multiple databases, but now also you have to juggle search path and when I used schemas our databases backups were insane. This is because two same name tables with same name indexes can't be compressed together, as I understand it. I would also be very careful about using roles this way as it makes connection pool formulas a lot more magical and less deterministic.