Postgres Pro
Downloads
Home   >   mailing lists

Re: Schema Consolidation in PostgreSQL - Mailing list pgsql-admin

From David G. Johnston
Subject Re: Schema Consolidation in PostgreSQL
Date
Msg-id CAKFQuwYjxGMG1kFhc6vmE0FBUKAMwvuvD-cfBXbV-2cRwFDrYg@mail.gmail.com
Whole thread Raw
In response to Schema Consolidation in PostgreSQL  (Wei Shan <weishan.ang@gmail.com>)
Responses Re: Schema Consolidation in PostgreSQL  (Wei Shan <weishan.ang@gmail.com>)
List pgsql-admin
Tree view
On Thu, May 7, 2015 at 11:38 PM, Wei Shan <weishan.ang@gmail.com> 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 schemas

​​This 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.​

pgsql-admin by date:

Previous
From: John Scalia
Date:
Subject: Re: [HACKERS] INSERT ... ON CONFLICT UPDATE/IGNORE 4.0
Next
From: Wei Shan
Date:
Subject: Re: Schema Consolidation in PostgreSQL