3 ms·
> How does PostgreSQL compare to VoltDB? If you don't know the difference, you probably want Postgres. VoltDB is a specialty database for things like high fre
by Alex3917 11y ago
> How does PostgreSQL compare to VoltDB?
If you don't know the difference, you probably want Postgres.
VoltDB is a specialty database for things like high frequency trading. It wouldn't make sense to use for, say, a consumer app or web startup.
- davidw 11y agoYeah, if I start a new project, I default to Postgres: https://journal.dedasys.com/2015/02/21/i-default-to-postgres/ https://journal.dedasys.com/2015/02/21/i-default-to-postgres... I'd consider something else if I'm really, really sure that it's better suited to whatever niche problem than Postgres, but it'd take a lot of thinking and convincing myself.
- SEJeff 11y agoIn specific, it is a column store, which is advantageous to do things like real time analytics over millions of data points via streaming market data. This has uses for HFT, but also for anyone who wants to do their own day trading.
- Jweb_Guru 11y agoVoltDB isn't a column store. It's designed for serializable OLTP workloads with really fast index updates, neither of which characterize column stores. You may be thinking of one of Stonebraker's other projects, Vertica.
- SEJeff 11y agoGah, you nailed it. Sorry about that. Right guy, wrong db project that starts with a V.