From: Gene Selkov, Jr. <selkovjr@mcs.anl.gov>
To: Ludovic Marcotte <ludovic@Sophos.ca>
Cc: Chairudin Sentosa Harjo <chai@dnet.net.id>
Cc: pgsql-questions@postgresql.org <pgsql-sql@postgreSQL.org>
Subject: Re: [SQL] How do I split the data files into 2 hardisks?
Date: Thu, 06 Aug 1998 05:24:55 +0000
Message-ID: <35C93E27.194207E5@mcs.anl.gov> (raw)
References: <Pine.LNX.3.96.980805221104.31877A-100000@extra.Sophos.ca>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: selkovjr@mcs.anl.gov, ludovic@Sophos.ca, chai@dnet.net.id
Subject: Re: [SQL] How do I split the data files into 2 hardisks?
In-Reply-To: <35C93E27.194207E5@mcs.anl.gov>
References: <Pine.LNX.3.96.980805221104.31877A-100000@extra.Sophos.ca> <35C93E27.194207E5@mcs.anl.gov>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox