Restricting schema sizes

Поиск
Список
Период
Сортировка
От Kieren Scott
Тема Restricting schema sizes
Дата
Msg-id BAY149-w53D2CD9EDFAFED3996BF3EAE590@phx.gbl
обсуждение исходный текст
Ответы Re: Restricting schema sizes  (Scott Marlowe <scott.marlowe@gmail.com>)
Re: Restricting schema sizes  (Greg Smith <greg@2ndquadrant.com>)
Список 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.

В списке pgsql-admin по дате отправления:

Предыдущее
От: Joe Brenner
Дата:
Сообщение: Re: pg_ident.conf not working?
Следующее
От: Gabriele Bartolini
Дата:
Сообщение: Re: virtual ip's for Pg host