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