Postgres Pro
Downloads
Home   >   mailing lists

Thread: 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"

From
"surabhi.ahuja"
Date:
 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

Re: is there any way of specifying "i want x GB of space to be avaialble for my database"

From
Aaron Koning
Date:
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 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

Re: is there any way of specifying "i want x GB of space to be avaialble for my database"

From
Chris Browne
Date:
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/>