Subject RE: [firebird-support] Questions about FB file size limits
Author Johan van Zyl
OK, On Linux, 32-bit file I/O
it's 2GB and 64-bit file I/O, a few terabytes.
Which Linux is 32 bit and which is 64 bit
-----Original Message-----
From: Daniel Rail [mailto:daniel@...]
Sent: 30 August 2004 23:53
Subject: Re: [firebird-support] Questions about FB file size limits


At August 30, 2004, 18:15, Chad Z. Hower aka Kudzu wrote:

> :: Then it's not an OS limitation, but a FB limitation. And, an error in
> :: Helen's book, since she mentioned the limitation for external file
> :: size on NTFS is 4GB. But, I'll not hold her accountable, since it

> What is the limit on the DB itself?

Whatever the file and operating systems permit. With NTFS, it's
64-bit file I/O, but apparently it's really 48-bit I/O, basically a
few terabytes. With FAT32 on Win2000 and WinXP(I don't know about
Win95 and Win98), it's supposed to be 4GB. On Linux, 32-bit file I/O
it's 2GB and 64-bit file I/O, a few terabytes. With a Windows NTFS
and Linux 64-bit file I/O, you might have a greater chance to max out
the volume space than the file system limit. But, even with the
32-bit file I/O, you can have multi-file databases, which will give a
larger database than 2 or 4 GB.

Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (
ACCRA Med Software Inc. (

Yahoo! Groups Sponsor

Yahoo! Groups Links

a.. To visit your group on the web, go to:

b.. To unsubscribe from this group, send an email to:

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (
Version: 6.0.745 / Virus Database: 497 - Release Date: 2004/08/27

[Non-text portions of this message have been removed]