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

I get 100 MBps on 4 7200's, 2 on each SCSI-UW channel, all stipped into a
single /dev/md0 RAID-0 using 256-K chunks on RH62 and Intel Xeon 500 MHZ.
Fiber Channel drives are MUCH slower.

On Fri, 02 Jun 2000, Chris Albertson wrote:
> 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
--
JOE BRIGGS
DIR., NETWORK PRODUCTS
CYBERSTORAGE SYSTEMS
TEL 603-598-0005 x148