Subject Re: [Firebird-general] Max database size
Author Arno Brinkman
Hi,

> InterBase and Firebird have always had a 32-bit page number, so the
> total number of database pages that can be addressed is 4G, regardless
> of whether they're in one file or 1000 files. I don't know where the
> 7TB number came from - probably due to senile dementia, please feel free
> to remind me - but until we do a thorough redesign of the ODS, we're
> limited to 4G pages of whatever page size.

The pagenumber is signed and i remember code that check on a positive number thus the maximum number
is 31-bits IIRC.
Max. 2^31 * 16384 ?

Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Firebird open source database (based on IB-OE) with many SQL-99 features :
http://www.firebirdsql.org
http://www.firebirdsql.info
http://www.fingerbird.de/
http://www.comunidade-firebird.org/

Support list for Interbase and Firebird users :
firebird-support@yahoogroups.com

Nederlandse firebird nieuwsgroep :
news://newsgroups.firebirdsql.info