Database maximums

The following table describes the SQL maximums on such items as the number of database columns, names, and connections.
Table 1. Netezza Performance Server SQL maximums
Parameter Description
Columns Maximum per table or view: 1600. Maximum per distribution: 4
Names Maximum length of database and column names: 128 bytes
Characters Maximum number of characters in a char/varchar field: 64,000
Connections Maximum connections to the server: 2000. For and earlier, the default is 500. For and later, the default is 1000.
Row size Maximum row size: 65,535 bytes. Limit also applies to the result set of a query. Within each row, there is a small amount of overhead for special columns and other factors such as padding.