Re: SOC & user quotas - Mailing list pgsql-hackers

From Tom Lane
Subject Re: SOC & user quotas
Date
Msg-id 28110.1172797712@sss.pgh.pa.us
Whole thread Raw
In response to Re: SOC & user quotas  ("Sergey E. Koposov" <math@sai.msu.ru>)
Responses Re: SOC & user quotas
List pgsql-hackers
"Sergey E. Koposov" <math@sai.msu.ru> writes:
> I still  don't understand how FS quotas can help with DB quotas. ..
> All the FS quotas are setup for limiting  the space for specific user and 
> specific mount point. AFAIK They do not allow to limit the space in one 
> directory. And since all the PG tablespaces will be owned by postgres 
> user, I dont think the FS quotas can do the job.

Well, you have to put the tablespace on a mount point that's not
otherwise used by Postgres, but beyond that I don't see the problem.

The point here is not that it's amazingly simple or convenient to use;
obviously it isn't.  The point is that it's *possible* to get this sort
of effect today, and so we have to ask whether it's really worth a good
deal of development effort and code complexity to provide somewhat
more convenient, but basically duplicate, functionality within Postgres.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Sergey E. Koposov"
Date:
Subject: Re: SOC & user quotas
Next
From: "Sergey E. Koposov"
Date:
Subject: Re: SOC & user quotas