Re: Maximum table size ?

Posted in 1998

Art S. Kagel — Wed, 27 May 1998 17:24:26 -0400 — source: Informix-list mailing list archive (1991-1998)

Helmut Leininger wrote: > > Hi, > > Is there a limit on the table size and/or number of rows in a table in > Informix Online 7.xx? > Maybe this information is somewhere in the manuals but I did not find > it. It is in the release notes in: $INFORMIXDIR/release/en_us/0333/SERVERS_7.? A tablespace is limited to 16million pages or 2^32 rows, a table may be made up of up to 1000 tablespaces as fragments. Actually while the engine is limited to 1000 tablespaces it is also limited to 1000 disk chunks (which can be 4K or 2K depending on the system) so the practical limit is <4TB (1000 * 2^32 or 1000 * 2^31). Art S. Kagel