Re: 2GB file size limit

From: teg(at)redhat(dot)com (Trond Eivind =?iso-8859-1?q?Glomsr=F8d?=)
To: "Thalis A(dot) Kalfigopoulos" <thalis(at)cs(dot)pitt(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: 2GB file size limit
Date: 2001-05-22 02:05:32
Message-ID: xuyu22edtoz.fsf@halden.devel.redhat.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Thalis A. Kalfigopoulos" <thalis(at)cs(dot)pitt(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message CaT 2001-05-22 02:07:57 Re: 2GB file size limit
Previous Message GH 2001-05-22 02:00:14 Re: 2GB file size limit