What is the best way to restrict/limit the size that a schema can grow too in Postgresql?
If I want to have a scratchpad area within my database to allow users to create tables, how can I control the size of the objects they can create?
Would I have to create a dedicated filesystem and then create a tablespace on that filesystem. Users could then create objects in that tablespace until they fill the filesystem.
Is there a setting in Postgresql whereby I can allocate a quota of space within a tablespace for each schema?
The other option I can think of is writing a script that monitors the size of the objects within a schema. The danger here is that a user could potentially create a huge table as a result of a bad query (cartesian join etc) and fill the application tablespace / filesystem.
