0

I am looking for open-source alternatives to SQL Server Enterprise Edition for a mostly-read analytics workload. The main key features that I'm looking for are

  • Column-oriented storage
  • Parallel query execution - in particular, sorts/group by etc. should use multiple cores, like SQL Server does.
  • Clustering / horizontal scaling options. I am not interested in sharding or shared-nothing as much as I am in being able to add additional CPUs to a single (logical) DB instance.

I looked at PostgreSQL with cstore_fdw, which gets a column-store but individual queries are still single-threaded.

What else should I be looking at?

closed as off-topic by mustaccio, Laurenz Albe, Marcello Miorelli, Philᵀᴹ, Michael Green Oct 11 at 13:13

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Shopping list question - questions about which tool, library, product or resource you should use are off-topic here because they quickly become obsolete and often are just about the preferences of the answerer. If you have an issue with or a question about a specific tool, please revise your question to conform to that scope." – mustaccio, Laurenz Albe, Marcello Miorelli, Philᵀᴹ, Michael Green
If this question can be reworded to fit the rules in the help center, please edit the question.

0

Depending on your queries, postgresql + citus + cstore_fdw may solve your problems. Citus (with sharding) can parallelize your queries, and cstore_fdw provides columnar storage.

Not the answer you're looking for? Browse other questions tagged or ask your own question.