Skip to main content

Vertica performance with HUGE fact tables

  • January 23, 2018
  • 1 reply
  • 4 views

chaima
Forum|alt.badge.img+2
  • Participating Frequently

Hi team,
We need feedback on Vertica performance with very large tables.
Our customer will have fact tables with 100 to 300 billion rows and is wondering whether Vertica can handle such volumes and is worried about the performance issues that would entail.

What are the best practices when dealing with such huge tables;
Do we have customers with such tables?
Any feedback would be very appreciated

Kind regards,
Chaima

1 reply

Ben_Vandiver
Forum|alt.badge.img
  • Participating Frequently
  • January 23, 2018

I think we've got at least 2 customers with > 10 trillion row tables...