Skip site navigation (1) Skip section navigation (2)

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

From: joe briggs <jbriggs(at)cyberstorage(dot)com>
To: Chris Albertson <calbertson(at)logicon(dot)com>, Ohgaki Yasuo <yasuo_ohgaki(at)hotmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Database/table limits ??????
Date: 2000-06-02 18:23:43
Message-ID: 00060214260608.06662@vs.borgland.com (view raw or flat)
Thread:
Lists: pgsql-admin
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(at)logicon(dot)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


In response to

pgsql-admin by date

Next:From: pyzDate: 2000-06-02 18:26:58
Subject: Re: Re: Future plans for raw devices ?
Previous:From: Bruce MomjianDate: 2000-06-02 18:12:35
Subject: Re: Re: Future plans for raw devices ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group