Re: [HACKERS] quotas once again
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
Re: [HACKERS] quotas once again
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: [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] 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 | [EMAIL PROTECTED] 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
[HACKERS] 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 ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] quotas once again
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 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 [EMAIL PROTECTED] 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
Re: [HACKERS] quotas once again
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 [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? 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 [EMAIL PROTECTED] 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 [EMAIL PROTECTED]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
Re: [HACKERS] quotas once again
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 too late Pavel --- 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 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 [EMAIL PROTECTED] 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 [EMAIL PROTECTED]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
Re: [HACKERS] quotas once again
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 [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? 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 [EMAIL PROTECTED] 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 [EMAIL PROTECTED]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
Re: [HACKERS] quotas once again
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? 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
Re: [HACKERS] quotas once again
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 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 | [EMAIL PROTECTED] 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
Re: [HACKERS] quotas once again
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 Architect | phone: 732.331.1324 EnterpriseDB Corporation| fax: 732.331.1301 499 Thornall Street, 2nd Floor | [EMAIL PROTECTED] Edison, NJ 08837| http://www.enterprisedb.com/ ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster