Re: Largest filesize under Linux

From: Christopher Browne <cbbrowne(at)acm(dot)org>
To: pgsql-hackers(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Re: Largest filesize under Linux
Date: 2003-03-11 20:01:44
Message-ID: m3bs0hvfiv.fsf@chvatal.cbbrowne.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general pgsql-hackers

Quoth "Partho Bhowmick" <pbhowmick(at)sbcglobal(dot)net>:
> I am working on extending the functionality of PostgreSQL on Linux.
> I need to know what's the largest filesize for a single file that I can have
> under Linux?

That depends.

It depends on the size supported by the filesystem. Usually that's at
least 2TB, these days. (For ext2) Any of the interesting alternative
FSes (xfs, jfs, reiserfs) offer Way Big file sizes, >2TB.

But you also need for the file size to be supported by:
a) GLIBC, and
b) The kernel VFS.

I believe that recent kernels and GLIBCs allow arbitrary large files,
but you will have to check on your favorite kernel and libraries, as
milage may vary. And it's disputable whether or not that is
necessarily going to be a "Linux" question...
--
output = reverse("moc.enworbbc@" "enworbbc")
http://www3.sympatico.ca/cbbrowne/fs.html
"One often contradicts an opinion when what is uncongenial is really
the tone in which it was conveyed." -- Nietzsche

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Partho Bhowmick 2003-03-11 21:05:11 Re: Largest filesize under Linux
Previous Message girlyDBA 2003-03-11 19:30:16 keys allowed in child which do not exist in parent table when restoring using pg_restore

Browse pgsql-general by date

  From Date Subject
Next Message Joseph Shraibman 2003-03-11 20:17:29 Re: ERROR: out of free buffers: time to abort!
Previous Message David C.Oshel 2003-03-11 19:31:00 Apple's Java 1.4.1 seems to have broken DBVisualizer?

Browse pgsql-hackers by date

  From Date Subject
Next Message Dave Page 2003-03-11 20:35:29 Website build script
Previous Message Dave Page 2003-03-11 19:22:46 Re: Roadmap for FE/BE protocol redesign