Max Row Count per Table

[JimKnicely]

FYI...

I was asked recently by a client what is the max number of rows per table Vertica can handle.

From the docs, we see that it is "2^64 rows per node".

Note that 2^64 = 1.84467440737096e+19, which equates to 18,446,744,073,709,600,000 rows per table per node!

Wow, that's a lot of rows!

See:

http://my.vertica.com/docs/7.1.x/HTML/i ... ual|_____2

Note: Table size is limited to: 2^64 rows per node, or 2^63 bytes per column, whichever is smaller.

[NorbertKrupa]

It's also important to note the row size limit:

32,768,000 bytes. The row size is approximately the sum of its maximum column sizes, where, for example, a VARCHAR(80) has a maximum size of 80 bytes.