Re: Best way to limit database sizes

From: Tino Schwarze <postgresql(at)tisc(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Best way to limit database sizes
Date: 2008-07-03 19:17:36
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-admin

On Thu, Jul 03, 2008 at 09:10:47PM +0200, Dimitri Fontaine wrote:

> >I've considered creating a tablespace in a directory owned by the
> >user , so I can use Linux quotas to prevent higher disk usage , but
> >this turned out be a bad thought, as all the files are anyway owned
> >by the postgres user and so disk quotas won't have any effect.
> What if you put each tablespace on a LVM partition of a control sized,
> extensible?

This is a desaster waiting to happen. I'd say never let a database get
out of disk space. Rather implement soft limits like regular cron jobs
and make them pay for overusage.

Also note that DB size on disk and amount of data stored in DB might be
a lot different because of bloating issues, indices etc.

Tino..oO(But LVM/tablespace should work.)

"What we nourish flourishes." - "Was wir nähren erblüht."

In response to


Browse pgsql-admin by date

  From Date Subject
Next Message Carol Walter 2008-07-03 19:45:45 Who's attached to the database?
Previous Message Dimitri Fontaine 2008-07-03 19:10:47 Re: Best way to limit database sizes