From: | "Poul L(dot) Christiansen" <poulc(at)cs(dot)auc(dot)dk> |
---|---|
To: | Jonas Lindholm <jonas(dot)lindholm(at)omgroup(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Maximum size of one table |
Date: | 2001-03-14 15:40:45 |
Message-ID: | 3AAF90FD.3D108D1E@cs.auc.dk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
PG will split the table into several files, to avoid the 2GB limit.
But you might run into problems if you do a pg_dump and the output is >
2GB. The workaround is to use "gzip" and "split" or you could upgrade to
the newest kernel 2.4, which AFAIK doesn't have the 2GB limit.
Poul L. Christiansen
Jonas Lindholm wrote:
>
> Can a table grow larger than maximum file size ?
> E.g. will PG create an additional file for the table ?
>
> I'm running PG 7.0.3 on Linux where the maximum file size is 2GB
>
> Thanks
> /Jonas Lindholm
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
From | Date | Subject | |
---|---|---|---|
Next Message | Daniel A. Melo | 2001-03-14 15:45:59 | Re: Re: compilation error <segunda parte> |
Previous Message | pejac | 2001-03-14 15:37:56 | re : Please Help |