Re: Maximum size of one table

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