is there any way of specifying "i want x GB of space to be avaialble for my database"
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
Show quoted text
On 12/5/05, surabhi.ahuja <surabhi.ahuja@iiitb.ac.in> wrote:
here is a question
say 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,
regards
surabhi
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/>