Subject Re: [firebird-support] Maximum single file database size?
Author Daniel Rail

At August 20, 2004, 03:07, Dan Wilson wrote:

> On 8/20/2004 at 5:45 AM rithban wrote:

>> I've been told that the maximum size (on Windows) for a single-file
>> database on Interbase < v7.1 is 4GB.
>> Is this still true for Firebird, or has that limit been eliminated?
>> I'm using IB6 right now and hit the limit, and would prefer to stay OSS.

> Firebird 1.5 and 1.5.1 support 64-bit file i/o on file systems
> like NTFS that support that.

It's been in place since Firebird 1.0 on Windows. And, with Linux, it
depends if the kernel supports 64-bit file I/O.

> Win2K and later are fine, provided you
> have formatted the drive as NTFS and not FAT-32. Under Win 95, 98,
> and ME IIRC you have a 2GB file size limit imposed by
> FAT-32.

Under FAT-32, the limit is 4GB. Under Linux 32-bit file I/O, it's

> I'm not sure about NT4.

With NTFS, it's not a problem. Your more likely to hit the volume
limit than the max file size limit.

And, at the present time, there's a per table size limit that was
reported(some say 40GB and some say 80GB), but that limit will be
removed in Firebird 2.0.

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