User Guide : D. Limits
 
Share this page                  
Limits
Limits
Following is a summary of Vector limits:
Parameter
Limit
Maximum database size
Unlimited; files can be spread across devices
Maximum tables in a database
1.1 billion
Maximum files per database
N/A
Maximum files per instance
N/A
Maximum page size
N/A
Maximum cache buffers
140 terabytes (2^47 bytes)
Maximum rows per table
140 trillion (2^47)
Maximum row width per table
256 KB
Maximum fields (columns) per table
2048
Maximum fields (columns) per index
32
Maximum locations per database
1024
Maximum locations per table
32 table locations; 1024 column locations
Maximum locations per column
32
Maximum integer size
64 bits (INTEGER8)
Maximum decimal precision
38 digits
Maximum float precision
64-bit IEEE (FLOAT8)
Maximum length of a character field
32,000 bytes
Maximum length of a varchar field
32,000 bytes
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
382
Maximum size of Positional Delta Tree (PDT)
4 billion modified (inserted, updated, deleted) records per table
Unicode support
UTF-8 and UCS-2 (UTF-16 without surrogate support)
XML support
Consume and publish