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