Postgresql and resource isolation - Mailing list pgsql-general

From Garber, Mikhail
Subject Postgresql and resource isolation
Date
Msg-id 5B6EE82A8CF89149BA864458DB605347037C06D74C@EX-SEA5-A.ant.amazon.com
Whole thread Raw
Responses Re: Postgresql and resource isolation  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: Postgresql and resource isolation  (Andrew Sullivan <ajs@crankycanuck.ca>)
List 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 by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: 8.3 vs 8.2 sql compatiblity issue
Next
From: Tom Lane
Date:
Subject: Re: 8.3 vs 8.2 sql compatiblity issue