From: | selkovjr(at)mcs(dot)anl(dot)gov |
---|---|
To: | "Byron Joseph Bacaltos" <byronjo(at)hotmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Size Limit |
Date: | 2000-06-14 07:00:46 |
Message-ID: | 200006140737.CAA18797@mail.xnet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> 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
From | Date | Subject | |
---|---|---|---|
Next Message | selkovjr | 2000-06-14 07:08:17 | Re: Help: How to store query output in a file !!! |
Previous Message | Dustin Sallings | 2000-06-14 04:26:46 | Re: Question reagarding serial type. |