From: | "Gene Selkov, Jr(dot)" <selkovjr(at)mcs(dot)anl(dot)gov> |
---|---|
To: | Ludovic Marcotte <ludovic(at)Sophos(dot)ca> |
Cc: | Chairudin Sentosa Harjo <chai(at)dnet(dot)net(dot)id>, "pgsql-questions(at)postgresql(dot)org" <pgsql-sql(at)postgreSQL(dot)org> |
Subject: | Re: [SQL] How do I split the data files into 2 hardisks? |
Date: | 1998-08-06 05:24:55 |
Message-ID: | 35C93E27.194207E5@mcs.anl.gov |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Ricardo Romero | 1998-08-06 05:46:55 | UNSUBSCRIBE |
Previous Message | Ludovic Marcotte | 1998-08-06 02:13:51 | Re: [SQL] How do I split the data files into 2 hardisks? |