Sometime ago there was a discussion about user/database quota and
IIRC there was also some patch for this (probably got rejected).

Does anyone know to which direction we went for having quotas?

Regards,
Gevik
------------------------------------------------
Gevik Babakhani

PostgreSQL NL http://www.postgresql.nl
TrueSoftware BV http://www.truesoftware.nl
------------------------------------------------


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Hello

this patch was commited

http://archives.postgresql.org/pgsql...1/msg00530.php

Regards
Pavel Stehule

On 28/11/2007, Gevik Babakhani <pgdev@xs4all.nl> wrote:
> Sometime ago there was a discussion about user/database quota and
> IIRC there was also some patch for this (probably got rejected).
>
> Does anyone know to which direction we went for having quotas?
>
> Regards,
> Gevik
> ------------------------------------------------
> Gevik Babakhani
>
> PostgreSQL NL http://www.postgresql.nl
> TrueSoftware BV http://www.truesoftware.nl
> ------------------------------------------------
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Pavel Stehule wrote:
> Hello
>
> this patch was commited
>
> http://archives.postgresql.org/pgsql...1/msg00530.php

Uh, he was asking about "quotas", not "quotes". No, we don't have user
quotas yet.

---------------------------------------------------------------------------



>
> Regards
> Pavel Stehule
>
> On 28/11/2007, Gevik Babakhani <pgdev@xs4all.nl> wrote:
> > Sometime ago there was a discussion about user/database quota and
> > IIRC there was also some patch for this (probably got rejected).
> >
> > Does anyone know to which direction we went for having quotas?
> >
> > Regards,
> > Gevik
> > ------------------------------------------------
> > Gevik Babakhani
> >
> > PostgreSQL NL http://www.postgresql.nl
> > TrueSoftware BV http://www.truesoftware.nl
> > ------------------------------------------------
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 1: if posting/reading through Usenet, please send an appropriate
> > subscribe-nomail command to majordomo@postgresql.org so that your
> > message can get through to the mailing list cleanly
> >
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq

--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://postgres.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

On 28/11/2007, Bruce Momjian <bruce@momjian.us> wrote:
> Pavel Stehule wrote:
> > Hello
> >
> > this patch was commited
> >
> > http://archives.postgresql.org/pgsql...1/msg00530.php
>
> Uh, he was asking about "quotas", not "quotes". No, we don't have user
> quotas yet.
>

I am blind. I am sorry. Its too late

Pavel


> ---------------------------------------------------------------------------
>
>
>
> >
> > Regards
> > Pavel Stehule
> >
> > On 28/11/2007, Gevik Babakhani <pgdev@xs4all.nl> wrote:
> > > Sometime ago there was a discussion about user/database quota and
> > > IIRC there was also some patch for this (probably got rejected).
> > >
> > > Does anyone know to which direction we went for having quotas?
> > >
> > > Regards,
> > > Gevik
> > > ------------------------------------------------
> > > Gevik Babakhani
> > >
> > > PostgreSQL NL http://www.postgresql.nl
> > > TrueSoftware BV http://www.truesoftware.nl
> > > ------------------------------------------------
> > >
> > >
> > > ---------------------------(end of broadcast)---------------------------
> > > TIP 1: if posting/reading through Usenet, please send an appropriate
> > > subscribe-nomail command to majordomo@postgresql.org so that your
> > > message can get through to the mailing list cleanly
> > >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 3: Have you checked our extensive FAQ?
> >
> > http://www.postgresql.org/docs/faq
>
> --
> Bruce Momjian <bruce@momjian.us> http://momjian.us
> EnterpriseDB http://postgres.enterprisedb.com
>
> + If your life is a hard drive, Christ can be your backup. +
>

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

> Uh, he was asking about "quotas", not "quotes". No, we don't
> have user quotas yet.
>

Thank you.

I read we have a "Allow per-tablespace quotas". But the more I think about
this
the more complex it gets. I guess implementing a user quota is a very
different story
than quotas per-tablespace.

------------------------------------------------
Gevik Babakhani

PostgreSQL NL http://www.postgresql.nl
TrueSoftware BV http://www.truesoftware.nl
------------------------------------------------

>
>
> >
> > Regards
> > Pavel Stehule
> >
> > On 28/11/2007, Gevik Babakhani <pgdev@xs4all.nl> wrote:
> > > Sometime ago there was a discussion about user/database quota and
> > > IIRC there was also some patch for this (probably got rejected).
> > >
> > > Does anyone know to which direction we went for having quotas?
> > >
> > > Regards,
> > > Gevik
> > > ------------------------------------------------
> > > Gevik Babakhani
> > >
> > > PostgreSQL NL http://www.postgresql.nl
> > > TrueSoftware BV http://www.truesoftware.nl
> > > ------------------------------------------------
> > >
> > >
> > > ---------------------------(end of
> > > broadcast)---------------------------
> > > TIP 1: if posting/reading through Usenet, please send an
> appropriate
> > > subscribe-nomail command to
> majordomo@postgresql.org so that your
> > > message can get through to the mailing list cleanly
> > >
> >
> > ---------------------------(end of
> > broadcast)---------------------------
> > TIP 3: Have you checked our extensive FAQ?
> >
> > http://www.postgresql.org/docs/faq
>
> --
> Bruce Momjian <bruce@momjian.us> http://momjian.us
> EnterpriseDB
> http://postgres.enterprisedb.com
>
> + If your life is a hard drive, Christ can be your backup. +
>


---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

On Nov 28, 2007 3:21 PM, Gevik Babakhani <pgdev@xs4all.nl> wrote:
> Sometime ago there was a discussion about user/database quota and
> IIRC there was also some patch for this (probably got rejected).
>
> Does anyone know to which direction we went for having quotas?

I had written a patch for user quotas back in 2004. While the patch
is probably long gone, if you're interested, I'd be willing to assist
in its development.

--
Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324
EnterpriseDB Corporation | fax: 732.331.1301
499 Thornall Street, 2nd Floor | jonah.harris@enterprisedb.com
Edison, NJ 08837 | http://www.enterprisedb.com/

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Jonah H. Harris escribió:
> On Nov 28, 2007 3:21 PM, Gevik Babakhani <pgdev@xs4all.nl> wrote:
> > Sometime ago there was a discussion about user/database quota and
> > IIRC there was also some patch for this (probably got rejected).
> >
> > Does anyone know to which direction we went for having quotas?
>
> I had written a patch for user quotas back in 2004. While the patch
> is probably long gone, if you're interested, I'd be willing to assist
> in its development.

Did you publish it in pgsql-patches? If so, it can be fished from
there.

--
Alvaro Herrera http://www.amazon.com/gp/registry/DXLWNGRJD34J
"You're _really_ hosed if the person doing the hiring doesn't understand
relational systems: you end up with a whole raft of programmers, none of
whom has had a Date with the clue stick." (Andrew Sullivan)

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

On Nov 28, 2007 8:09 PM, Alvaro Herrera <alvherre@alvh.no-ip.org> wrote:
> Did you publish it in pgsql-patches? If so, it can be fished from
> there.

Unfortunately, no. IIRC, I believe the topic moved to being
non-user-based quotas and more tablespace-oriented.

--
Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324
EnterpriseDB Corporation | fax: 732.331.1301
499 Thornall Street, 2nd Floor | jonah.harris@enterprisedb.com
Edison, NJ 08837 | http://www.enterprisedb.com/

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

After reading the thread of 2004 regarding user quotas, I understand
why the discussion moved towards having a tablespace quota as a
solution.

My reason to start this discussion was due the need of controlling
database size. Having tablespace quotas could allow one to create a
database in a given tablespace and then limit the size of the tablespace.

------------------------------------------------
Gevik Babakhani

PostgreSQL NL http://www.postgresql.nl
TrueSoftware BV http://www.truesoftware.nl
------------------------------------------------


> -----Original Message-----
> From: pgsql-hackers-owner@postgresql.org
> [mailtogsql-hackers-owner@postgresql.org] On Behalf Of
> Jonah H. Harris
> Sent: Thursday, November 29, 2007 3:55 AM
> To: Alvaro Herrera
> Cc: Gevik Babakhani; pgsql-hackers@postgresql.org
> Subject: Re: [HACKERS] quotas once again
>
> On Nov 28, 2007 8:09 PM, Alvaro Herrera
> <alvherre@alvh.no-ip.org> wrote:
> > Did you publish it in pgsql-patches? If so, it can be fished from
> > there.
>
> Unfortunately, no. IIRC, I believe the topic moved to being
> non-user-based quotas and more tablespace-oriented.
>
> --
> Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324
> EnterpriseDB Corporation | fax: 732.331.1301
> 499 Thornall Street, 2nd Floor |
> jonah.harris@enterprisedb.com
> Edison, NJ 08837 | http://www.enterprisedb.com/
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>


---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate

Gevik Babakhani wrote:
> After reading the thread of 2004 regarding user quotas, I understand
> why the discussion moved towards having a tablespace quota as a
> solution.
>
> My reason to start this discussion was due the need of controlling
> database size. Having tablespace quotas could allow one to create a
> database in a given tablespace and then limit the size of the tablespace.

You can control tablespace size by filesystem quotas. When you put each
tablespace on separate FS. Hovewer, disadvantage is that you need admin
access to the machine and it is not controlled by postgres. ZFS works
fine in this case, because you can delegate volume/filesystem
administration to the any user and FS creation is very easy.

Zdenek

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend