B. Ingres Limits
 
Share this page                  
Ingres Limits
Summary of Limits
Following is a summary of Ingres limits:
Parameter
Limit
Maximum database size
1,000 EB (exabytes)
Maximum tables in a database
1.1 billion
Maximum files per database
2 billion
Maximum files per instance
Limit based on file systems.
Maximum page size
64 KB
Maximum cache buffers
4 GB on 32-bit systems
16 EB on 64-bit systems
Limited by hardware/OS memory architecture.
Maximum rows per table
34.5 trillion
Maximum row size per table
256 KB
Limit does not include LOBs.
Maximum fields (columns) per table
1024
Maximum indexes per table
126
Maximum file size per index
512 GB
Maximum fields (columns) per index
32
Maximum integer size
64 bits
Maximum decimal precision
39 digits
Maximum float precision
Hardware dependent
Maximum length of a character field
32,000 bytes
If II_CHARSETxx=UTF8,16,000 bytes
Maximum length of a varchar field
32,000 bytes
If II_CHARSETxx=UTF8,16,000 bytes
Maximum size of a CLOB
2 GB
Maximum size of a BLOB
2 GB
Maximum size of an SQL statement
Unlimited
Maximum members in an IN list
Unlimited
Maximum logical operators in a WHERE clause
Unlimited
Maximum join conditions
Unlimited
Maximum tables in a join statement
126
Unicode support
UTF-8 and UCS-2 (UTF-16 without surrogate support)
XML support
Consume and publish