From: Kieren Scott <kierenscott@hotmail.com>
To: pgsql-admin@postgresql.org
Subject: Restricting schema sizes
Date: Sun, 17 Oct 2010 11:02:23 +0000
Message-ID: <BAY149-w53D2CD9EDFAFED3996BF3EAE590@phx.gbl> (raw)
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.
=
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: kierenscott@hotmail.com
Subject: Re: Restricting schema sizes
In-Reply-To: <BAY149-w53D2CD9EDFAFED3996BF3EAE590@phx.gbl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox