Theoretical Maximum Number of Rows Per Table Per Node

Posted August 1, 2019 by Jim Knicely, Vertica Principal Solution Architect

Tips and Tricks Orange Button
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/latest/HTML/Content/Authoring/SQLReferenceManual/SystemLimits.htm

Have fun!