| 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: | Whole Thread | Raw Message | 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 |