From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Ohgaki Yasuo <yasuo_ohgaki(at)hotmail(dot)com> |
Cc: | Chris Albertson <calbertson(at)logicon(dot)com>, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Database/table limits ?????? |
Date: | 2000-06-02 01:30:01 |
Message-ID: | 200006020130.VAA07276@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Ross J. Reedstrom | 2000-06-02 04:09:16 | Re: Database/table limits ?????? |
Previous Message | Ohgaki Yasuo | 2000-06-02 01:23:23 | Re: Database/table limits ?????? |