Theoretical Maximum Number of Rows Per Table Per Node

Jim_Knicely

The Vertica Table size limit is documented to be 2^64 rows per node. Just how big is that number?

dbadmin=> SELECT TO_CHAR(2^64, '99,999,999,999,999,999,999') "Really, really BIG!";
     Really, really BIG!
-----------------------------
  18,446,744,073,709,551,616
(1 row)

That’s 18+ Sextillion rows!

I’ve been tracking in a Vertica table the number of text messages my daughter has sent/received since she first got a cell phone at the age of twelve. Now twelve years later I’m about to exceed the Vertica row limit!

dbadmin=> SELECT TO_CHAR(COUNT(*), '999,999,999,999,999,999,999') "Just One More?" FROM my_daughters_text_messages;
        Just One More?
-----------------------------
  18,446,744,073,709,551,616 
(1 row)

dbadmin=> INSERT INTO my_daughters_text_messages VALUES (1);
ERROR 54014: ERRCODE_TOO_MANY_ROWS – TELL YOUR DAUGHTER TO STOP TEXTING!

Just kidding.

Helpful Link:
https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/SQLReferenceManual/SystemLimits.htm

Have fun!