Thread: PgSQL users quota

Hi .*<br /><br />Is there any chance to see the quota implementation described in this post in any next releases?<br
/><br/><a
href="http://archives.postgresql.org/pgsql-hackers/2004-07/msg00392.php">http://archives.postgresql.org/pgsql-hackers/2004-07/msg00392.php
</a><br/><br /><br />Thanks you!<br />----<br />Nick<br /> 

On Fri, Oct 20, 2006 at 03:30:40AM +0300, Tux P wrote:
> Hi .*
> 
> Is there any chance to see the quota implementation described in this post
> in any next releases?
> 
> http://archives.postgresql.org/pgsql-hackers/2004-07/msg00392.php

Since Jonah hasn't done anything with it he's presumably lost interest,
so you'd need to find someone else looking for an itch to scratch. And
it appears the original patch was against 7.4, so it'd probably need a
decent amount of work to make it work with our current code.

On the bright side, there is the following TODO item:

o Allow per-tablespace quotas
-- 
Jim Nasby                                            jim@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

On 10/23/06, Jim C. Nasby <jim@nasby.net> wrote:
> Since Jonah hasn't done anything with it he's presumably lost interest,
> so you'd need to find someone else looking for an itch to scratch. And
> it appears the original patch was against 7.4, so it'd probably need a
> decent amount of work to make it work with our current code.

Well, it was more of the case of community wants vs. what I needed at
the time.  I'm not quite sure if I have the patch lying around
anywhere, but it was fairly trivial to implement.

> o Allow per-tablespace quotas

Yes, this is what came out of the discussion.  A per-tablespace patch
should be fairly easy to implement once you get a consensus on what
constitutes actual space usage... as VACUUMable space may or may not
apply depending on your use-case.

-- 
Jonah H. Harris, Software Architect | phone: 732.331.1300
EnterpriseDB Corporation            | fax: 732.331.1301
33 Wood Ave S, 2nd Floor            | jharris@enterprisedb.com
Iselin, New Jersey 08830            | http://www.enterprisedb.com/

Thanks for your response.

Waiting on anyone to implement this feature ;))
-----
Nick