Re: [GENERAL] Tablespace limit feature

2014-11-06 Thread Stephen Frost
* Jim Nasby (jim.na...@bluetreble.com) wrote: > On 11/4/14, 2:10 PM, Alvaro Herrera wrote: > >Alejandro Carrillo escribió: > >>> > >>>But This feature is very necessary to control the amount space expensed by > >>>a postgresql user or tablespace. This feature could be used in PostgreSQL > >>>Shar

Re: [GENERAL] Tablespace limit feature

2014-11-06 Thread Jim Nasby
On 11/4/14, 2:10 PM, Alvaro Herrera wrote: Alejandro Carrillo escribió: > >But This feature is very necessary to control the amount space expensed by a postgresql user or tablespace. This feature could be used in PostgreSQL Sharing Hosting, see: Shared Database Hosting - PostgreSQL wiki Sure.

Re: [GENERAL] Tablespace limit feature

2014-11-04 Thread Alvaro Herrera
Alejandro Carrillo escribió: > > But This feature is very necessary to control the amount space expensed by a > postgresql user or tablespace. This feature could be used in PostgreSQL > Sharing Hosting, see: Shared Database Hosting - PostgreSQL wiki Sure. Rub hits the road when it comes to act

Re: [GENERAL] Tablespace limit feature

2014-11-04 Thread Alejandro Carrillo
But This feature is very necessary to control the amount space expensed by a postgresql user or tablespace. This feature could be used in PostgreSQL Sharing Hosting, see: Shared Database Hosting - PostgreSQL wiki |   | |   |   |   |   |   | | Shared Database Hosting - PostgreSQL wikiThe objecti

Re: [GENERAL] Tablespace limit feature

2014-11-04 Thread Stephen Frost
* John R Pierce (pie...@hogranch.com) wrote: > On 11/4/2014 9:00 AM, Alejandro Carrillo wrote: > >I need to limit the tablespace file because I need to control the > >hard disk space used in a tablespace > > so what happens if a query does something that violates the quota? It gets cancelled. Se

Re: [GENERAL] Tablespace limit feature

2014-11-04 Thread John R Pierce
On 11/4/2014 9:00 AM, Alejandro Carrillo wrote: I need to limit the tablespace file because I need to control the hard disk space used in a tablespace so what happens if a query does something that violates the quota? I can see one difficulty in implementation would be just keeping track of h

Re: [GENERAL] Tablespace limit feature

2014-11-04 Thread Stephen Frost
* Guillaume Lelarge (guilla...@lelarge.info) wrote: > Yeah. I guess there are a lot of questions yet to be answered. But AFAIUI, > there's no real technical issue. More like discussions to agree on what it > should do and how. Didn't mean to imply there was some specific technical issue. We have

Re: [GENERAL] Tablespace limit feature

2014-11-04 Thread Rob Sargent
On 11/04/2014 10:09 AM, Guillaume Lelarge wrote: Le 4 nov. 2014 18:00, "Alejandro Carrillo" > a écrit : > > I need to limit the tablespace file because I need to control the hard disk space used in a tablespace. Anybody knows how to do this? Or if it this in the Pos

Re: [GENERAL] Tablespace limit feature

2014-11-04 Thread David W Noon
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tue, 4 Nov 2014 17:00:54 + (UTC), Alejandro Carrillo (faster...@yahoo.es) wrote about "Re: [GENERAL] Tablespace limit feature" (in <1781968257.697829.1415120454794.javamail.ya...@jws3.mail.ir2.yahoo.com>): > I need to l

Re: [GENERAL] Tablespace limit feature

2014-11-04 Thread Guillaume Lelarge
Le 4 nov. 2014 17:59, "Stephen Frost" a écrit : > > * Guillaume Lelarge (guilla...@lelarge.info) wrote: > > Le 4 nov. 2014 16:29, "Stephen Frost" a écrit : > > > Having quotas and limits for users is something which I've wanted for a > > > long time, but it's not likely to happen any time particu

Re: [GENERAL] Tablespace limit feature

2014-11-04 Thread Guillaume Lelarge
Le 4 nov. 2014 18:00, "Alejandro Carrillo" a écrit : > > I need to limit the tablespace file because I need to control the hard disk space used in a tablespace. Anybody knows how to do this? Or if it this in the PostgreSQL roadmap? > Well, Stephen already answered this. There's no way yet to do t

Re: [GENERAL] Tablespace limit feature

2014-11-04 Thread Alejandro Carrillo
I need to limit the tablespace file because I need to control the hard disk space used in a tablespace. Anybody knows how to do this? Or if it this in the PostgreSQL roadmap? Thanks El Martes 4 de noviembre de 2014 11:52, Guillaume Lelarge escribió: Le 4 nov. 2014 16:29, "St

Re: [GENERAL] Tablespace limit feature

2014-11-04 Thread Stephen Frost
* Guillaume Lelarge (guilla...@lelarge.info) wrote: > Le 4 nov. 2014 16:29, "Stephen Frost" a écrit : > > Having quotas and limits for users is something which I've wanted for a > > long time, but it's not likely to happen any time particularly soon.. > > Lack of time or technical issue? For the

Re: [GENERAL] Tablespace limit feature

2014-11-04 Thread Guillaume Lelarge
Le 4 nov. 2014 16:29, "Stephen Frost" a écrit : > > * Alejandro Carrillo (faster...@yahoo.es) wrote: > > Can PostgreSQL's tablespace limit space in MB? Or exists another way to limit space in a table of a tablespace?? > > You can set up quotas on the underlying filesystem, but that will limit > th

Re: [GENERAL] Tablespace limit feature

2014-11-04 Thread Stephen Frost
* Alejandro Carrillo (faster...@yahoo.es) wrote: > Can PostgreSQL's tablespace limit space in MB? Or exists another way to limit > space in a table of a tablespace?? You can set up quotas on the underlying filesystem, but that will limit the entire tablespace. Having quotas and limits for users

Re: [GENERAL] Tablespace limit feature

2014-11-04 Thread Adrian Klaver
On 11/04/2014 07:05 AM, Alejandro Carrillo wrote: Hi, Can PostgreSQL's tablespace limit space in MB? Or exists another way to limit space in a table of a tablespace?? Not that I know of. What exactly is the issue you are facing? Maybe there is another way to achieve what you want. Thank