Subject Re: [ib-support] Max. DatabaseSize 64-Bit I/O
Author Christian Gütter
Hi Jason,

> What OS? You can't AFAIK get anywhere near this with Windows.

Excerpt from:
http://support.microsoft.com/default.aspx?scid=kb;en-us;114841

------------------------
File Systems
FAT and HPFS both have internal limits of 4 GB due to the fact that they
use 32-bit fields to store file sizes. NTFS uses 64-bit fields for all
sizes, permitting its data structures to handle volumes up to 2^64 bytes
(16 exabytes or 18,446,744,073,709,551,616 bytes).

This value is the theoretical limit for the NTFS file system. Practical
limits having to do with the maximum allowable partition size described
above limit the size of an NTFS partition to approximately 2 terabytes.
Because the 32-bit fields of the partition table refer to the number of
sectors in the partition, disks with larger sector sizes translate into
larger permissible partition sizes. Currently Windows NT supports sector
sizes up to 4 Kilobytes. With 4KB sectors, Windows NT can support a 16
terabyte partition. As new hardware or software schemes become
available, NTFS will be able to handle substantially larger volume
sizes.
------------------------

Of course, I haven't tested this ;-)
Anyway, I believe that the practical limits are much
lower.


With regards,

Christian