Re: 2 gig file size limit

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: neilconway(at)home(dot)com
Cc: nwalker(at)eldocomp(dot)com, pgsql-hackers(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org, pgsql-patches(at)postgresql(dot)org
Subject: Re: 2 gig file size limit
Date: 2001-07-11 01:01:48
Message-ID: 200107110101.f6B11nC23950@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers pgsql-jdbc pgsql-patches

> (This question was answered several days ago on this list; please check
> the list archives before posting. I believe it's also in the FAQ.)
>
> > If PostgreSQL is run on a system that has a file size limit (2
> > gig?), where might cause us to hit the limit?
>
> Postgres will never internally use files (e.g. for tables, indexes,
> etc) larger than 1GB -- at that point, the file is split.
>
> However, you might run into problems when you export the data from Pg
> to another source, such as if you pg_dump the contents of a database >
> 2GB. In that case, filter pg_dump through gzip or bzip2 to reduce the
> size of the dump. If that's still not enough, you can dump individual
> tables (with -t) or use 'split' to divide the dump into several files.

I just added the second part of this sentense to the FAQ to try and make
it more visible:

The maximum table size of 16TB does not require large file
support from the operating system. Large tables are stored as
multiple 1GB files so file system size limits are not important.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tatsuo Ishii 2001-07-11 01:09:26 Re: TCL and encoding
Previous Message Chad R. Larson 2001-07-11 00:03:12 Re: upgrading postgres from 7.0 to 7.1

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2001-07-11 01:02:36 Re: Postgresql bulk fast loader
Previous Message Bruce Momjian 2001-07-11 00:59:42 Re: SOMAXCONN (was Re: Solaris source code)

Browse pgsql-jdbc by date

  From Date Subject
Next Message Thomas Lockhart 2001-07-11 01:41:26 Re: Re: Backups WAS: 2 gig file size limit
Previous Message Neil Conway 2001-07-10 23:17:05 Re: 2 gig file size limit

Browse pgsql-patches by date

  From Date Subject
Next Message Thomas Lockhart 2001-07-11 01:41:26 Re: Re: Backups WAS: 2 gig file size limit
Previous Message Bruce Momjian 2001-07-11 00:58:30 Re: patch for spelling mistake