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博客 ” ，链接：https://blog.itpub.net/10037372/viewspace-718369/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
转载--ftp中bin和ascii的区别
请登录后发表评论
登录
全部评论
