Re: [SQL] How do I split the data files into 2 hardisks?

On Thu, 6 Aug 1998, Chairudin Sentosa Harjo wrote:

> Hi all,
> 
> I like this mailing list, very helpful.
> I have a question regarding splitting data file to more than 1 hardisks.
> 
> Currently I have 2 x 2 GB hardisks.
> I would like to split files in directory
> /usr/local/pgsql/data/base/databasename
> to 2 hardisks.
> 
> The reason is I want to dump 3 GB ~ 4 GB of data from oracle to postgres to
> do testing.
> I want to know whether postgres can handle 3 GB ~ 4 GB data, and so some
> performance benchmarking. ( Oracle vs Postgres )
> 
> I don't have one 4 GB hardisk, so I have to split them.
> I am using Linux.
> Could any one help me ?

If your using Linux you can throw those 2 disks in a RAID configuration
as to form one logical disk. You can try striping (RAID 1???) or RAID5 I 
guess....

Maarten

_____________________________________________________________________________
| TU Delft, The Netherlands, Faculty of Information Technology and Systems  |
|                   Department of Electrical Engineering                    |
|           Computer Architecture and Digital Technique section             |
|                          M.Boekhold@et.tudelft.nl                         |
-----------------------------------------------------------------------------