Forum: VoltDB Architecture

Post: Sizing

Sizing
TobiasBraeutigam
Aug 9, 2010
Hi all,


I evaluate VoltDB for data warehousing purposes.
Will available RAM limit DB size?
We need to handle > 5 TB.


Thanks in advance
Tobias Bräutigam
re: Sizing
tcallaghan
Aug 10, 2010
Tobias,


VoltDB is an in-memory purpose-built database for OLTP workloads. All of your table data and indexes must reside in the total physical memory of your VoltDB cluster. Building a 5TB cluster with k-safety would be very expensive.


If the application you are considering for VoltDB has both OLTP and OLAP components, we recommend using VoltDB for the OLTP and spooling the transactional data (when static) into an OLAP database for warehousing.


-Tim