O'Reilly logo

Greenplum - Architecture and SQL by Leona Coffing, Tom Coffing

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 4 – The Technical Details

“In the end we’ll remember not the words of our enemies, but the silence of our friends.”

– Martin Luther King, Jr.

Greenplum Limitations

Database Size

Unlimited

Table Size

Unlimited

Partition Size

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)

As you can see Greenplum has few limitations.

Every Segment has the Exact Same Tables

image

To get perfect ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required