| From: | Neil Conway <nconway(at)klamath(dot)dyndns(dot)org> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: 2GB file size limit |
| Date: | 2001-05-22 02:10:56 |
| Message-ID: | 20010521221056.A319@klamath.dyndns.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, May 21, 2001 at 09:31:13PM -0400, 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?
Postgres splits table files after 1GB, so the file size limit shouldn't
affect the maximum table size. I'm not sure what the other limits are,
though. My guess is you can probably make as large a database as you
have the storage space for.
Cheers,
Neil
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John | 2001-05-22 02:48:58 | perl vs php for postgresql |
| Previous Message | Trond Eivind =?iso-8859-1?q?Glomsr=F8d?= | 2001-05-22 02:09:01 | Re: 2GB file size limit |