Thread: Size Limit

Sir,

I am currently using ingres and would like to migrate to postgres.
However the problem is that my existing database is now over  2GB and all of
my scsi disks are only at 2GB.  In ingres all I have to do to extend large
tables to multiple locations or file systems  (disks) thereby enabling me to
look into my table as if it is residing in a single disk.  Is this posible
with postgres? or is there such thing as one database but multiple locations
with postgres?

Hoping for your immediate response.


Sincerely,


Byron Joseph A. Bacaltos

________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

> Sir,
>
> I am currently using ingres and would like to migrate to postgres.
> However the problem is that my existing database is now over  2GB and all of
> my scsi disks are only at 2GB.  In ingres all I have to do to extend large
> tables to multiple locations or file systems  (disks) thereby enabling me to
> look into my table as if it is residing in a single disk.  Is this posible
> with postgres?

It is possible with most unix kernels, it is known as "disk striping",
a.k.a. RAID0.

As a kludge, you might want to scatter the tables across multiple
filesystems and symlink them into the database directory. That will
work if no table is larger than 2Gb. When a table reaches 2Gb, you can
let it grow a little over, enough to get split, then move out the
surplus (not sure whether postgres splits tables in systems other than
linux).

--Gene

One quick and dirty way could be to create symbolic links from files in
pgsql/data/base to an equivalent folder on your respective disks.

On Tue, 13 Jun 2000, Byron Joseph Bacaltos wrote:

> Sir,
>
> I am currently using ingres and would like to migrate to postgres.
> However the problem is that my existing database is now over  2GB and all of
> my scsi disks are only at 2GB.  In ingres all I have to do to extend large
> tables to multiple locations or file systems  (disks) thereby enabling me to
> look into my table as if it is residing in a single disk.  Is this posible
> with postgres? or is there such thing as one database but multiple locations
> with postgres?
>
> Hoping for your immediate response.
>
>
> Sincerely,
>
>
> Byron Joseph A. Bacaltos
>
> ________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
>