Hi all,
Thanks for the replies so far.
When I say resource manager, I actually meant if there's a way to ensure the maximum resource utilization by a certain user. For example in Oracle, we can actually limit a certain user by setting a resource plan on it. Resource can be CPU.
Thanks!
On 9 May 2015 12:16 am, "David G. Johnston" <david.g.johnston@xxxxxxxxx> wrote:
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 schemasThis doesn't make sense and, regardless, the use of "resource" here to too generic to comment upon.Is there any resource manager.Both the O/S and the database manage resources...2. Can I get schema-level performance statistics? If I see that this schema is overloaded, I may move it to another server.Like Albe said - you can get statistics by object, and know in which schemas those objects reside.David J.
