Subject Re: [firebird-support] Questions about FB file size limits
Author Ivan Prenosil
Database consists of pages, and they are indexed using 32 bits.
Hence maximal theoretical db file size is
page_size * 4GB


----- Original Message -----
From: "Daniel Rail" <daniel@...>
To: <>
Sent: Monday, August 30, 2004 11:53 PM
Subject: Re: [firebird-support] Questions about FB file size limits

> Hi,
> 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. (