Re: Tablespace limit feature

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Alejandro Carrillo <fasterzip(at)yahoo(dot)es>
Cc: PostgreSQL General <pgsql-general(at)postgresql(dot)org>, Stephen Frost <sfrost(at)snowman(dot)net>
Subject: Re: Tablespace limit feature
Date: 2014-11-04 17:09:49
Message-ID: CAECtzeX3R59oQ1tWqWkGNPrQMRcAm-G7g3z1hE0=UbttXBwBDw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Le 4 nov. 2014 18:00, "Alejandro Carrillo" <fasterzip(at)yahoo(dot)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(at)lelarge(dot)info> escribió:
>>
>>
>>
>> Le 4 nov. 2014 16:29, "Stephen Frost" <sfrost(at)snowman(dot)net> a écrit :
>> >
>> > * Alejandro Carrillo (fasterzip(at)yahoo(dot)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)
>>
>>
>>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Guillaume Lelarge 2014-11-04 17:14:25 Re: Tablespace limit feature
Previous Message Alejandro Carrillo 2014-11-04 17:00:54 Re: Tablespace limit feature