Maximum Limits of Greenplum Database
Greenplum® Database 4.2
The gadget spec URL could not be found
Database Size : Unlimited
Table Size: Unlimited, 128 TB per partition per segment
Row Size:1.6 TB (1600 columns * 1 GB)
Field Size:1 GB
Rows per Table:281474976710656 (2^48)
Columns per Table/View:1600
Indexes per Table:Unlimited
Columns per Index:32
Table-level Constraints per Table:Unlimited
Table Name Length:63 Bytes (Limited by name data type)
The gadget spec URL could not be found
Greenplum® Database 4.3 (No change from previous version)
Database Size: Unlimited
Table Size: Unlimited, 128 TB per partition per segment
Row Size: 1.6 TB (1600 columns * 1 GB)
Field Size: 1 GB
Rows per Table: 281474976710656 (2^48)
Columns per Table/View: 1600
Indexes per Table: Unlimited
Columns per Index: 32
Table-level Constraints per Table: Unlimited
Table Name Length: 63 Bytes (Limited by name data type)
Greenplum Database Limits:
| Dimension | Limit |
| Maximum size for a database? | unlimited |
| Maximum size for a table? | unlimited, 128 TB per partition per segment |
| Maximum size for a row? | >1 GB (approximate) |
| Maximum size for a field? | 1 GB |
| Maximum BLOB size | 1 GB (Use BYTEA datatype, we don't have BLOB) |
| Maximum number of rows in a table? | 2^48 |
| Maximum number of columns in a table? | 1600 |
| Maximum number of indexes on a table? | unlimited |
| Maximum number of databases/users | unlimited |
| Maximum number of tables per database | 4200 million |
| Maximum number of columns per View | unlimited |
| Maximum length of column/table name | 63 |
| Maximum number of columns per index | unlimited |
| Maximum number of table level constraints per table | unlimited |
| Maximum active concurrent transactions | unlimited |
| Maximum data format descriptor size | 63 characters |
| Maximum database, user, base table, view, index, trigger, stored procedure, UDF, UDT, constraint or column name size. | 63 characters |
| Maximum sessions per parsing engine | No concept of parsing engine other than masterDB node. No fixed limit, up to a few hundred. |
Dimensions listed as unlimited are not intrinsically limited by Greenplum Database. However, they are limited in practice to available disk space and memory/swap space. Performance may suffer when these values get unusually large.
Note: There is a maximum limit on the number of objects (such as tables, views, indexes, but not rows) that may exist at one time. This limit is 4294967296 (2^32).
The gadget spec URL could not be found
Datatype Limits Oracle 11.2
| Datatypes | Limit | Comments |
|---|
BFILE | Maximum size: 4 GB Maximum size of a file name: 255 characters Maximum size of a directory name: 30 characters Maximum number of open BFILEs: see Comments | The maximum number of BFILEs is limited by the value of theSESSION_MAX_OPEN_FILES initialization parameter, which is itself limited by the maximum number of open files the operating system will allow. |
BLOB | Maximum size: (4 GB - 1) * DB_BLOCK_SIZEinitialization parameter (8 TB to 128 TB) | The number of LOB columns per table is limited only by the maximum number of columns per table (that is, 1000Foot 1 ). |
CHAR | Maximum size: 2000 bytes | None |
CHAR VARYING | Maximum size: 4000 bytes | None |
CLOB | Maximum size: (4 GB - 1) * DB_BLOCK_SIZEinitialization parameter (8 TB to 128 TB) | The number of LOB columns per table is limited only by the maximum number of columns per table (that is, 1000Footref 1). |
| Literals (characters or numbers in SQL or PL/SQL) | Maximum size: 4000 characters | None |
LONG | Maximum size: 2 GB - 1 | Only one LONG column is allowed per table. |
NCHAR | Maximum size: 2000 bytes | None |
NCHAR VARYING | Maximum size: 4000 bytes | None |
NCLOB | Maximum size: (4 GB - 1) * DB_BLOCK_SIZEinitialization parameter (8 TB to 128 TB) | The number of LOB columns per table is limited only by the maximum number of columns per table (that is, 1000Footref 1). |
NUMBER | 999...(38 9's) x10125 maximum value -999...(38 9's) x10125 minimum value | Can be represented to full 38-digit precision (the mantissa) Can be represented to full 38-digit precision (the mantissa) |
| Precision | 38 significant digits | None |
RAW | Maximum size: 2000 bytes | None |
VARCHAR | Maximum size: 4000 bytes | None |
VARCHAR2 | Maximum size: 4000 bytes | None |
