Re: 2GB file size limit

From: Philip Hallstrom <philip(at)adhesivemedia(dot)com>
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 01:54:56
Message-ID: 20010521185410.R52464-100000@oddjob.adhesivemedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm pretty sure I remember one of the developers saying that postgres
works around this limit automatically by creating separate tables per
database/table/etc...

in other words it's not a problem. if I'm wrong, someone who knows
correct me.

-philip

On Mon, 21 May 2001, Thalis A. Kalfigopoulos wrote:

> Hello all,
> 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?
> Any ideas how to work around this other than upgrading glibc or changing OS or architecture? Having survived through Slackware evolution, I bet it'll be the last to adopt any changes in the field *sigh*
>
> thanks in advance,
> thalis
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message GH 2001-05-22 02:00:14 Re: 2GB file size limit
Previous Message Craig Orsinger 2001-05-22 01:50:48 NOTIFY/LISTEN Using Embedded SQL (ecpg)