surabhi.ahuja@xxxxxxxxxxx ("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/>