Re: Tablespace limit feature - Mailing list pgsql-general

From Guillaume Lelarge
Subject Re: Tablespace limit feature
Date
Msg-id CAECtzeX3R59oQ1tWqWkGNPrQMRcAm-G7g3z1hE0=UbttXBwBDw@mail.gmail.com
Whole thread Raw
In response to Re: Tablespace limit feature  (Alejandro Carrillo <fasterzip@yahoo.es>)
Responses Re: Tablespace limit feature
List pgsql-general

Le 4 nov. 2014 18:00, "Alejandro Carrillo" <fasterzip@yahoo.es> 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 this with PostgreSQL. You might get something like this with filesystem quotas.

And it's not on PostgreSQL roadmap, because there's no such thing. I don't know anyone working on this.

>
> Thanks
>
> El Martes 4 de noviembre de 2014 11:52, Guillaume Lelarge <guillaume@lelarge.info> escribió:
>>
>>
>>
>> Le 4 nov. 2014 16:29, "Stephen Frost" <sfrost@snowman.net> a écrit :
>> >
>> > * Alejandro Carrillo (fasterzip@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 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 latter, may I ask which issue you see? (I might be interesting in pursuing this)
>>
>>
>>

pgsql-general by date:

Previous
From: Alejandro Carrillo
Date:
Subject: Re: Tablespace limit feature
Next
From: Guillaume Lelarge
Date:
Subject: Re: Tablespace limit feature