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

[Aaron Koning <aaronkoning@xxxxxxxxx>]

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@xxxxxxxxxxx> 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