Re: Database fixed size

So how did heroku limit the database size per user?
I thought about creating triggers on insert and updates but that will lead
to bad performance

On Wed, Sep 28, 2016, 15:31 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> writes:
> > Adir Shaban wrote:
> >> Is there anyway to limit a database size?
> >> For example, I need to create a database for user X and I don't want it
> to use more than 5 GB.
>
> > You can create a tablespace on a device with limited size.
> > Then you can create the database on that tablespace.
>
> Note the reference to tablespace. It's unwise to just put the whole
> cluster on a tiny device (or equivalently, attempt to solve this with
> OS-level disk quotas applied to the whole installation). The reason is
> that PG gets very unhappy if it runs out of WAL space. Hitting a limit
> on table size per se behaves a bit more sanely, though even there you
> can get into trouble --- for instance, in some situations VACUUM will
> try to allocate additional disk space, making recovery harder.
>
> regards, tom lane
>