Greenplum Database Maximum Limits

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:

DimensionLimit
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 size1 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/usersunlimited
Maximum number of tables per database4200 million
Maximum number of columns per Viewunlimited
Maximum length of column/table name63
Maximum number of columns per indexunlimited
Maximum number of table level constraints per tableunlimited
Maximum active concurrent transactionsunlimited
Maximum data format descriptor size63 characters
Maximum database, user, base table, view, index, trigger, stored procedure, UDF, UDT, constraint or column name size.63 characters
Maximum sessions per parsing engineNo 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

DatatypesLimitComments
BFILEMaximum 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.
BLOBMaximum 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 ).
CHARMaximum size: 2000 bytesNone
CHAR VARYINGMaximum size: 4000 bytesNone
CLOBMaximum 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 charactersNone
LONGMaximum size: 2 GB - 1Only one LONG column is allowed per table.
NCHARMaximum size: 2000 bytesNone
NCHAR VARYINGMaximum size: 4000 bytesNone
NCLOBMaximum 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).
NUMBER999...(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)

Precision38 significant digitsNone
RAWMaximum size: 2000 bytesNone
VARCHARMaximum size: 4000 bytesNone
VARCHAR2Maximum size: 4000 bytesNone
Comments