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