RE: 2GB file size limit

From: "Albertson, Chris" <CAlbertson(at)primeadvantage(dot)com>
To: "'Thalis A(dot) Kalfigopoulos'" <thalis(at)cs(dot)pitt(dot)edu>, pgsql-general(at)postgresql(dot)org
Subject: RE: 2GB file size limit
Date: 2001-05-22 21:34:10
Message-ID: 71EFB3F67FADD3119C0A00508B55444196626A@mailtest123.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


You don't need large files. Postgres will use multiple
files for large tables.

"OIDs" are 32-bit integers. You can "only" have 2^^32
records in your database. This is a hard limit last I
checked. Don't know of anyone hitting it yet. I may
in a couple years but am not close yet.

> -----Original Message-----
> From: Thalis A. Kalfigopoulos [mailto:thalis(at)cs(dot)pitt(dot)edu]
> Sent: Monday, May 21, 2001 6:31 PM
> To: pgsql-general(at)postgresql(dot)org
> Subject: [GENERAL] 2GB file size limit
>
>
> 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
>
This email message is for the sole use of the intended recipient(s) and may
contain proprietary and confidential information. Any unauthorized review,
use, disclosure or distribution is prohibited. If you are not the intended
recipient, please contact the sender by reply email and destroy all copies
of the original message. Thank you

Browse pgsql-general by date

  From Date Subject
Next Message Thalis A. Kalfigopoulos 2001-05-22 22:21:22 Re: Re: Select statement
Previous Message Mihai Gheorghiu 2001-05-22 21:33:21 Re: Can't find destroydb