pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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



view thread (4+ messages)  latest in thread

Message-ID: <35C93E27.194207E5@mcs.anl.gov>
Permalink:  ../35C93E27.194207E5@mcs.anl.gov/
Also on:    postgresql.org/message-id/35C93E27.194207E5@mcs.anl.gov

 · 

reply

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