Schema Consolidation in PostgreSQL

[Wei Shan <weishan.ang@xxxxxxxxx>]

Hi all!

I have a database with multiple schemas consolidated within a postgres database.

I have 2 issues when working with this setup.

1. How can I ensure that there's no resource contention between the schemas? Is there any resource manager. 

2. Can I get schema-level performance statistics? If I see that this schema is overloaded, I may move it to another server.

Thanks!

--

Regards,
Ang Wei Shan