PgSQL users quota

Started by Tux Pabout 19 years ago4 messages
#1Tux P
gentuu@gmail.com

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

Thanks you!
----
Nick

#2Jim C. Nasby
jim@nasby.net
In reply to: Tux P (#1)
Re: PgSQL users quota

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)

#3Jonah H. Harris
jonah.harris@gmail.com
In reply to: Jim C. Nasby (#2)
Re: PgSQL users quota

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/

#4Tux P
gentuu@gmail.com
In reply to: Jonah H. Harris (#3)
Re: PgSQL users quota

Thanks for your response.

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

2006/10/23, Jonah H. Harris <jonah.harris@gmail.com>:

Show quoted text

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/