Re: Database/table limits ?????? - Mailing list pgsql-admin

From Bruce Momjian
Subject Re: Database/table limits ??????
Date
Msg-id 200006020130.VAA07276@candle.pha.pa.us
Whole thread Raw
In response to Re: Database/table limits ??????  ("Ohgaki Yasuo" <yasuo_ohgaki@hotmail.com>)
Responses Re: Database/table limits ??????  ("Ross J. Reedstrom" <reedstrm@rice.edu>)
List pgsql-admin
[ Charset ISO-8859-1 unsupported, converting... ]
> I understand OID is signed integer which go up to  2^31.
> Almost any case it would be sufficient. (It's sufficient for me, at least)
>
> What I really want to know is the same as original poster.
>
> > > 8. Can a database be spread over more than one disk drive?

Yes, by creating symbolic links for the files in data/base/dbname.


> > > 9. Can a table be spread over more than one disk drive?

Yes, if it gets over 1GB, it is split and a new file created.  Symbolic
links allow them to be moved.

> > > If the answer to 8 and or 9 is yes, how do I do it?

--
  Bruce Momjian                        |  http://www.op.net/~candle
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-admin by date:

Previous
From: "Ohgaki Yasuo"
Date:
Subject: Re: Database/table limits ??????
Next
From: "Ross J. Reedstrom"
Date:
Subject: Re: Database/table limits ??????