Postgresql and resource isolation

Поиск
Список
Период
Сортировка
От Garber, Mikhail
Тема Postgresql and resource isolation
Дата
Msg-id 5B6EE82A8CF89149BA864458DB605347037C06D74C@EX-SEA5-A.ant.amazon.com
обсуждение исходный текст
Ответы Re: Postgresql and resource isolation  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: Postgresql and resource isolation  (Andrew Sullivan <ajs@crankycanuck.ca>)
Список pgsql-general
Hello,

We are considering using Postgresql for rather large project and I have questions about where it stands in respect to
thefollowing. 

Consider these two features already found in major commercial products.

A) "resource governor" - the ability to configure how much resources (IO per second, CPU slices) particular users or
sessionsare allowed to use 

B) ability to collect statistics about how much IO and CPU particular users and sessions actually use


I understand that I should be able to get at least some IO data by querying pg_stat_* views, but what about getting
numbersabout CPU usage? 
And more general question - what are the plans to support these and similar features in Postgresql?

Thanks!


В списке pgsql-general по дате отправления:

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: 8.3 vs 8.2 sql compatiblity issue
Следующее
От: Tom Lane
Дата:
Сообщение: Re: 8.3 vs 8.2 sql compatiblity issue