Re: [GENERAL] Database fixed size

2016-09-28 Thread Adir Shaban
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

Re: [GENERAL] Database fixed size

2016-09-28 Thread Tom Lane
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

Re: [GENERAL] Database fixed size

2016-09-28 Thread Albe Laurenz
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 -

Re: [GENERAL] Database fixed size

2016-09-28 Thread amul sul
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.

[GENERAL] Database fixed size

2016-09-28 Thread Adir Shaban
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.