On 27.06.2007 16:58, Dawid Kuroczko wrote:
> On 6/27/07, Hannes Dorbath <light@theendofthetunnel.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_quotacommand.
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