Maximum Limits of Greenplum Database

Greenplum® Database 4.2

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 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:

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).