From: | Kieren Scott <kierenscott(at)hotmail(dot)com> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Restricting schema sizes |
Date: | 2010-10-17 11:02:23 |
Message-ID: | BAY149-w53D2CD9EDFAFED3996BF3EAE590@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi,
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.
Many thanks.
From | Date | Subject | |
---|---|---|---|
Next Message | Gabriele Bartolini | 2010-10-17 11:07:33 | Re: virtual ip's for Pg host |
Previous Message | Joe Brenner | 2010-10-16 20:49:59 | Re: pg_ident.conf not working? |