Re: "Quota"

On 27.06.2007 16:58, Dawid Kuroczko wrote:
> On 6/27/07, Hannes Dorbath <light(at)theendofthetunnel(dot)de> wrote:
>> What would be a solution to prevent a single user/schema to fill the
>> disk using PostgreSQL? Is it a good idea to use separate table spaces?
>
> I am contemplating using XFS filesystem's quota to achieve per-directory quota. Basically what you need is use xfs_quota command.

That is exactly what I have now, I was just wondering if that's a bad idea.

> Nooow, as we are saying, XFS has yet another nice thing: xfs_fsr
> command which does online filesystem level defragmentation (for
> example as a nightly job). It does mix nicely with PostgreSQL's
> 1-GB table files.. :)

Yup, already in my crontab ;)

Thanks.

--
Regards,
Hannes Dorbath