Greenplum: Maximum Database Limits

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.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10037372/viewspace-718369/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10037372/viewspace-718369/