Database Administrator Guide > Database Administrator Guide > B. Limits
Was this helpful?
Limits
 
Summary of Limits
Summary of Limits
Limits for traditional Ingres and X100 are as follows:
Parameter
Ingres Limit
X100 Limit
Maximum database size
1,000 EB (exabytes)
Unlimited; files can be spread across devices
Maximum tables in a database
1.1 billion
1.1 billion
Maximum files per database
2 billion
N/A
Maximum files per instance
Limit based on file systems.
N/A
Maximum page size (for Ingres table)
64 KB
N/A
Maximum cache buffers
4 GB on 32-bit systems
16 EB on 64-bit systems
Limited by hardware/OS memory architecture
140 terabytes (2^47 bytes)
Maximum rows per table
34.5 trillion
140 trillion (2^47)
Maximum row size per table
256 KB
Limit does not include LOBs
256 KB
Maximum fields (columns) per table
1024
2048
Maximum indexes per table
126
N/A
Maximum file size per table index
512 GB
N/A
Maximum fields (columns) per index
32
32
Maximum integer size
64 bits
64 bits (INTEGER8)
Maximum decimal precision
39 digits
38 digits
Maximum float precision
Hardware dependent
64-bit IEEE (FLOAT8)
Maximum length of a character field
32,000 bytes
If II_CHARSETxx=UTF8,
16,000 bytes
32,000 bytes
Maximum length of a varchar field
32,000 bytes
If II_CHARSETxx=UTF8,
16,000 bytes
32,000 bytes
Maximum size of a CLOB
2 GB
N/A
Maximum size of a BLOB
2 GB
N/A
Maximum size of an SQL statement
Unlimited
Unlimited
Maximum members in an IN list
Unlimited
Unlimited
Maximum logical operators in a WHERE clause
Unlimited
Unlimited
Maximum join conditions
Unlimited
Unlimited
Maximum tables in a join statement
126
382
Unicode support
UTF-8 and UCS-2 (UTF-16 without surrogate support)
UTF-8 and UCS-2 (UTF-16 without surrogate support)
XML support
Consume and publish
Consume and publish
 
Last modified date: 01/30/2023