Re: Schema Consolidation in PostgreSQL

Поиск
Список
Период
Сортировка
От Wei Shan
Тема Re: Schema Consolidation in PostgreSQL
Дата
Msg-id CAFe9ZTo2dKk34o9ygfqWkBL5qgqAW4FZcJxQwFVV9wkr2p4-zw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Schema Consolidation in PostgreSQL  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: Schema Consolidation in PostgreSQL  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Список pgsql-admin
Дерево обсуждения

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@gmail.com> wrote:
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 по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: Schema Consolidation in PostgreSQL
Следующее
От: Albe Laurenz
Дата:
Сообщение: Re: Schema Consolidation in PostgreSQL