Subject Re: [firebird-support] Max dimension for a single database file
Author Paul Reeves
On Thursday 13 May 2004 09:52, Matteo Gadotti wrote:
> Hi, with firebird 1.5 Classic or Super Server, wath is the max
> dimension for a single file for a database?
> In a 32 bit system is 2Gb? And in 64 bit?
>

It is, at least at the moment, file system dependant. It is also, to some
extent, O/S dependant. Although I'm pretty sure all latest O/S versions
support 64 bit file i/o, so it comes back to the file system.

For example, with Ext2 or Ext3 and a 1KB block size the maximum file size
is 16GB. With a 2KB block size the max goes up to 256GB. You need to
check your file system documentation for more precise details.

The largest possible file size with 64 bit file i/o is 8EB, but I doubt
that you will hit this limit.


Paul
--
Paul Reeves
http://www.ibphoenix.com
Supporting users of Firebird and InterBase