On Tue, May 20, 2008 at 7:57 AM, pronix pronix <[EMAIL PROTECTED]> 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. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
