Re: [HACKERS] quotas once again

2007-12-11 Thread Zdenek Kotala
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

Re: [HACKERS] quotas once again

2007-11-29 Thread Gevik Babakhani
: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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 [EMAIL PROTECTED

[HACKERS] quotas once again

2007-11-28 Thread Gevik Babakhani
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

Re: [HACKERS] quotas once again

2007-11-28 Thread Pavel Stehule
Hello this patch was commited http://archives.postgresql.org/pgsql-committers/2007-11/msg00530.php Regards Pavel Stehule On 28/11/2007, Gevik Babakhani [EMAIL PROTECTED] wrote: Sometime ago there was a discussion about user/database quota and IIRC there was also some patch for this (probably

Re: [HACKERS] quotas once again

2007-11-28 Thread Bruce Momjian
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

Re: [HACKERS] quotas once again

2007-11-28 Thread Pavel Stehule
On 28/11/2007, Bruce Momjian [EMAIL PROTECTED] 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

Re: [HACKERS] quotas once again

2007-11-28 Thread Gevik Babakhani
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.

Re: [HACKERS] quotas once again

2007-11-28 Thread Alvaro Herrera
Jonah H. Harris escribió: On Nov 28, 2007 3:21 PM, Gevik Babakhani [EMAIL PROTECTED] 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?

Re: [HACKERS] quotas once again

2007-11-28 Thread Jonah H. Harris
On Nov 28, 2007 3:21 PM, Gevik Babakhani [EMAIL PROTECTED] 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

Re: [HACKERS] quotas once again

2007-11-28 Thread Jonah H. Harris
On Nov 28, 2007 8:09 PM, Alvaro Herrera [EMAIL PROTECTED] 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