Обсуждение: is there any way of specifying "i want x GB of space to be avaialble for my database"
is there any way of specifying "i want x GB of space to be avaialble for my database"
От
"surabhi.ahuja"
Дата:
here is a question
say i have a database and all the files(data files) indexes etc must be going to the PGDATA directory
The question is this:
is there any way by which i can specify : to reserve x GB amount of space to this database (this x includes all the space which the database will require space for data files, indexes or any other resources).
what i want to achieve by doing this is to limit the amount of rows i have inserted into the table and indexes etc.
Thanks,
regards
surabhi
If you are using a Linux system then you can make a partition of xGB and place PGDATA there. This may work for other OS as well.
Aaron
On 12/5/05, surabhi.ahuja <surabhi.ahuja@iiitb.ac.in> wrote:
here is a questionsay i have a database and all the files(data files) indexes etc must be going to the PGDATA directoryThe question is this:is there any way by which i can specify : to reserve x GB amount of space to this database (this x includes all the space which the database will require space for data files, indexes or any other resources).what i want to achieve by doing this is to limit the amount of rows i have inserted into the table and indexes etc.Thanks,regardssurabhi
surabhi.ahuja@iiitb.ac.in ("surabhi.ahuja") writes: > is there any way by which i can specify : to reserve x GB amount of > space to this database (this x includes all the space which the > database will require space for data files, indexes or any other > resources). I believe that is part of the intent of the TABLESPACE functionality that was recently added to PostgreSQL. <http://www.postgresql.org/docs/8.1/static/manage-ag-tablespaces.html> -- let name="cbbrowne" and tld="acm.org" in name ^ "@" ^ tld;; http://www.ntlug.org/~cbbrowne/linux.html Rules of the Evil Overlord #118. "If I have equipment which performs an important function, it will not be activated by a lever that someone could trigger by accidentally falling on when fatally wounded." <http://www.eviloverlord.com/>