
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/latest/HTML/Content/Authoring/SQLReferenceManual/SystemLimits.htm
Have fun!