Re: Database/table limits ??????

[ 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