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

Ohgaki Yasuo wrote:
>
> 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 two methods.
1) Use a RAID system, either hardware RAID or software RAID.
This also helps with performence but I find you get best performence
with one fast disk then with RAID built of of many slow disks.
for example I tried stiping four 7200RPM 50pin 20MBps drives
it wok OK but one new 10,000 LVD drive is faster.  The current
server here in the office has five LVD drives and is pretty quick.
We run Postgresql, MySQL, and CA Ingres on it.

2) Just move the files in .../pgsql/data some place and make links
I do this on my home system.


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

Yes (1) the RAID system will do this for you and (2) should
your table be so large that it spans multiple files you can
move and link some of the files.


--
  Chris Albertson

  calbertson@logicon.com                  Voice: 626-351-0089  x17
  Logicon, Pasadena California            Fax:   626-351-0699