1

I reckon that VoltDB uses compression but I'm not sure about that. Mike Stonebraker, who is the main creator of VoltDB, used to work on Vertica, which uses compression heavily. I heard about a case when somebody loaded a few GB of sequential integers and after loading the data the database size was barely about 1 GB.

ady
  • 1,108
  • 13
  • 19

1 Answers1

3

VoltDB is designed for maximum throughput & transaction processing performance, so it does not compress data for tables, views, or indexes stored in memory.

We have a blog post on database sizing, or how you can estimate the size of RAM needed for a use case and schema.

BenjaminBallard
  • 1,482
  • 12
  • 11
  • Surely there are operations on certain data sets for which "maximum throughput" would be enhanced by some form of compression. Also I'm surprised the answer is simply "no". There most be some encoding techniques used in the Db that qualify as compression – jberryman Feb 28 '18 at 23:18
  • VoltDB does use compression for snapshots (which are used for archiving data to disk, sending initial data to a node that is joining the cluster or to a replica cluster. However, the question was mainly about whether compression was used for the primary storage of user data (i.e. in memory) and VoltDB does not use compression for that. – BenjaminBallard Mar 01 '18 at 14:18