Theoretical Maximum Number of Rows Per Table Per Node
Jim_Knicely
- Select Field - Administrator
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!
Tagged:
0