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 wrote:
> Albe Laurenz writes:
> > Adir Shaban wrote:
> >> Is there anyway to limit a database size?
> >> For exa
Albe Laurenz 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 tabl
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.
Yours,
Laurenz Albe
-
On Wed, Sep 28, 2016 at 1:39 PM, Adir Shaban wrote:
> Hey,
>
> Is there anyway to limit a database size?
Nope.
check this
https://www.postgresql.org/message-id/619537.42270.qm%40web53708.mail.re2.yahoo.com
thread.
Regards,
Amul
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.
Hey,
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.