On Tue, May 20, 2008 at 7:57 AM, pronix pronix <pronix.service@xxxxxxxxx> wrote: > hello > how i can restrict dbusers ( user's db size, cpu time)? > how i can monitoring this parameters You can create table spaces for each user, and then create a db or schema or whatnot in that tablespace. If each tablespace is on a partition that is limited to some size, then you've limited the user's space. You don't get the more fine grained quotas that dbs like Oracle provide, but then again, since you're not spending $250,000 a year licensing postgresql, I guess you can buy a lot more space for the users to play in if they all share the same db. As for CPU time, there's really not restriction by user capability in postgresql at this time. To monitor it you can turn on stats collection and track what statements are using up the most CPU by pid.
