Received: from antares.mcs.anl.gov (mcs.anl.gov [140.221.9.6]) by hub.org (8.8.8/8.7.5) with SMTP id BAA04462 for ; Thu, 6 Aug 1998 01:26:36 -0400 (EDT) Received: from mcs.anl.gov (selkov.mcs.anl.gov [140.221.5.91]) by antares.mcs.anl.gov (8.6.10/8.6.10) with ESMTP id AAA27881; Thu, 6 Aug 1998 00:24:13 -0500 Sender: selkovjr@mcs.anl.gov Message-ID: <35C93E27.194207E5@mcs.anl.gov> Date: Thu, 06 Aug 1998 05:24:55 +0000 From: "Gene Selkov, Jr." X-Mailer: Mozilla 4.04 [en] (X11; I; Linux 2.0.32 i686) MIME-Version: 1.0 To: Ludovic Marcotte CC: Chairudin Sentosa Harjo , "pgsql-questions@postgresql.org" Subject: Re: [SQL] How do I split the data files into 2 hardisks? References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Ludovic Marcotte wrote: > > 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 ? > > > > Thanks > > > > Regards > > Chai > > > > Hi, > I don't know if PostgreSQL can do that.. but you could certainly > enabled the linear mode for 'disk appending' in your kernel. or use software RAID (a.k.a. "disk striping") wich may nealy double your disk performance if you use SCSI or attach IDE drives to separate controllers. http://linas.org/linux/Software-RAID/Software-RAID.html Gene > > Hope that helps, > Ludovic