Thread: quotas once again
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 ------------------------------------------------
Hello this patch was commited http://archives.postgresql.org/pgsql-committers/2007-11/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 >
Pavel Stehule wrote: > Hello > > this patch was commited > > http://archives.postgresql.org/pgsql-committers/2007-11/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. +
On 28/11/2007, Bruce Momjian <bruce@momjian.us> wrote: > Pavel Stehule wrote: > > Hello > > > > this patch was commited > > > > http://archives.postgresql.org/pgsql-committers/2007-11/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. + >
> 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. + >
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/
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)
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/
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 > [mailto:pgsql-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 >
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