pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
How do I split the data files into 2 hardisks?
4+ messages / 4 participants
[nested] [flat]

* How do I split the data files into 2 hardisks?
@ 1998-08-06 02:03 Chairudin Sentosa Harjo <chai@dnet.net.id>
  1998-08-06 02:13 ` Re: [SQL] How do I split the data files into 2 hardisks? Ludovic Marcotte <ludovic@Sophos.ca>
  1998-08-06 14:45 ` Re: [SQL] How do I split the data files into 2 hardisks? Maarten Boekhold <maartenb@dutepp2.et.tudelft.nl>
  0 siblings, 2 replies; 4+ messages in thread

From: Chairudin Sentosa Harjo @ 1998-08-06 02:03 UTC (permalink / raw)
  To: pgsql-sql

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





^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: [SQL] How do I split the data files into 2 hardisks?
  1998-08-06 02:03 How do I split the data files into 2 hardisks? Chairudin Sentosa Harjo <chai@dnet.net.id>
@ 1998-08-06 02:13 ` Ludovic Marcotte <ludovic@Sophos.ca>
  1998-08-06 05:24   ` Re: [SQL] How do I split the data files into 2 hardisks? Gene Selkov, Jr. <selkovjr@mcs.anl.gov>
  1 sibling, 1 reply; 4+ messages in thread

From: Ludovic Marcotte @ 1998-08-06 02:13 UTC (permalink / raw)
  To: Chairudin Sentosa Harjo <chai@dnet.net.id>; +Cc: pgsql-sql



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.

Hope that helps,
			Ludovic




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: [SQL] How do I split the data files into 2 hardisks?
  1998-08-06 02:03 How do I split the data files into 2 hardisks? Chairudin Sentosa Harjo <chai@dnet.net.id>
  1998-08-06 02:13 ` Re: [SQL] How do I split the data files into 2 hardisks? Ludovic Marcotte <ludovic@Sophos.ca>
@ 1998-08-06 05:24   ` Gene Selkov, Jr. <selkovjr@mcs.anl.gov>
  0 siblings, 0 replies; 4+ messages in thread

From: Gene Selkov, Jr. @ 1998-08-06 05:24 UTC (permalink / raw)
  To: Ludovic Marcotte <ludovic@Sophos.ca>; +Cc: Chairudin Sentosa Harjo <chai@dnet.net.id>; 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



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: [SQL] How do I split the data files into 2 hardisks?
  1998-08-06 02:03 How do I split the data files into 2 hardisks? Chairudin Sentosa Harjo <chai@dnet.net.id>
@ 1998-08-06 14:45 ` Maarten Boekhold <maartenb@dutepp2.et.tudelft.nl>
  1 sibling, 0 replies; 4+ messages in thread

From: Maarten Boekhold @ 1998-08-06 14:45 UTC (permalink / raw)
  To: Chairudin Sentosa Harjo <chai@dnet.net.id>; +Cc: pgsql-sql

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                         |
-----------------------------------------------------------------------------




^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~1998-08-06 14:45 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-08-06 02:03 How do I split the data files into 2 hardisks? Chairudin Sentosa Harjo <chai@dnet.net.id>
1998-08-06 02:13 ` Ludovic Marcotte <ludovic@Sophos.ca>
1998-08-06 05:24   ` Gene Selkov, Jr. <selkovjr@mcs.anl.gov>
1998-08-06 14:45 ` Maarten Boekhold <maartenb@dutepp2.et.tudelft.nl>

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