Subject RE: [ib-support] Max table size
Author Bert Hughes
Thanks, that's what I hoped & thought. We're creating a DB that will grow
quickly, a GIgabyte or so per month. Didn't want it to unexpectedly come
all crashing down five months from now.


-----Original Message-----
From: Leyne, Sean (Ext. 225) [mailto:sleyne@...]
Sent: Tuesday, February 25, 2003 2:58 PM
Subject: RE: [ib-support] Max table size


> Using the 64-bit IO version of Firebird (1.0.2 Linux) and
> linux filesystem
> ext3 (allows files > 2GB (4?)), how large can a single table be in a
> database that is stored in a single file?

Given that a table can contain multiple BLOB column and each blob can
contain 2GB of data, the limit for a single table is really the limit of
the physical database. I believe that the (current) theoretical limit
is 32TB.

Needless to say, no one has ever tested this limit, the largest single
database (which I'm aware of) is 980GB in size.

> Is it necessary to use multiple files if the database size
> grows > 4GB, or is this a pre-64bit version limit?

This is the pre-64bit limit.

Sean Leyne

Want to support Firebird development?
Become a member of the FirebirdSQL Foundation!

To unsubscribe from this group, send an email to:

Your use of Yahoo! Groups is subject to