Re: User Quota Implementation - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: User Quota Implementation
Date
Msg-id 200506101013.52759.josh@agliodbs.com
Whole thread Raw
In response to Re: User Quota Implementation  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: User Quota Implementation
Re: User Quota Implementation
List pgsql-hackers
Bruce, Yann,

> Sure.  Basically there has not been a lot of interest in this, and we
> are not sure how to implement it without a huge amount of work.
> Considering the other things we are working on, it hasn't been a
> priority, and lots of folks don't like the Oracle approach either.

Yeah.  I'd prefer per-database quotas, rather than per-user quotas, which
seem kind of useless.   The hard part is making any transaction which
would exceed the per-database quota roll back cleanly with a
comprehensible error message rather than just having the database shut
down.

If we had per-database user quotas, and per-database users, it would pretty
much wind up all of the issues which ISPs have with Postgres.

--
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Concrete proposal for large objects and MVCC
Next
From: Tom Lane
Date:
Subject: Re: User Quota Implementation