Actian X 11.2 | B. Limits

Was this helpful?

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	32,000 bytes
Maximum length of a varchar field	32,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: 04/03/2024