On 11/04/2014 10:09 AM, Guillaume Lelarge wrote:
>
> Le 4 nov. 2014 18:00, "Alejandro Carrillo" <fasterzip(at)yahoo(dot)es
> <mailto: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 <mailto:guillaume(at)lelarge(dot)info>> escribió:
> >>
> >>
> >>
> >> Le 4 nov. 2014 16:29, "Stephen Frost" <sfrost(at)snowman(dot)net
> <mailto:sfrost(at)snowman(dot)net>> a écrit :
> >> >
> >> > * Alejandro Carrillo (fasterzip(at)yahoo(dot)es
> <mailto: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)
> >>
> >>
> >>
>
Can you not partition the disk such that Postgres only has certain
partician(s)?