From: | "Poul L(dot) Christiansen" <poulc(at)cs(dot)auc(dot)dk> |
---|---|
To: | pejac(at)altern(dot)org |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Size limitation for a table under linux ........ |
Date: | 2000-10-18 10:11:41 |
Message-ID: | 39ED775D.ADF95534@cs.auc.dk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Just go ahead and create it. PostgreSQL will split the tables into
multiple files, to avoid the 2GB limitation.
When you do a pg_dump and the file is bigger than 2GB you will also have
a problem. That problem is solved by pipening the output to "gzip" and
possibly "split", if the zipped file is bigger than 2GB.
Poul L. Christiansen
pejac(at)altern(dot)org wrote:
>
> Hi,
>
> I want to know if we can create a table > 2 Go under
> linux because linux use ext2 ( and size file is limit to 2Go )
>
> Why postgresql don't use directly the device like other
> commercial DB ( sybase or oracle can permitt that ). Is it
> more performant ???
>
> So how can i create table with a size > 2Go under linux
> with postgresql.
>
> Thanks,
>
> PEJAC Pascal
>
From | Date | Subject | |
---|---|---|---|
Next Message | Gerhard Kroder | 2000-10-18 10:34:04 | test,sorry |
Previous Message | pejac | 2000-10-18 08:08:11 | Size limitation for a table under linux ........ |