Re: 2GB file size limit - Mailing list pgsql-general

From teg@redhat.com (Trond Eivind Glomsrød)
Subject Re: 2GB file size limit
Date
Msg-id xuyu22edtoz.fsf@halden.devel.redhat.com
Whole thread Raw
In response to 2GB file size limit  ("Thalis A. Kalfigopoulos" <thalis@cs.pitt.edu>)
List pgsql-general
"Thalis A. Kalfigopoulos" <thalis@cs.pitt.edu> writes:

> I upgraded from kernel 2.2.18 (Slakcware7.1 on x86) to 2.4.4
> only to find out that I will still not get LFS due to my glibc2.1.3.
> My question is the following: I know people have reported DBs larger
> than 2GB, but is there any single file that gets larger than 2GB?
> Can anyone make an estimate of what overall_DB_size will cause me to
> hit the 2GB-filesize limit?

AFAIK, postgresql will split the tables across multiple files anyway
(Oracles does it, at least) - which is good for backups etc. That you
can create big files doesn't mean you want to.

--
Trond Eivind Glomsrød
Red Hat, Inc.

pgsql-general by date:

Previous
From: Neil Conway
Date:
Subject: Re: 2GB file size limit
Next
From: CaT
Date:
Subject: Re: 2GB file size limit