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?

  • Take a look at MonetDB or Vector (Actian) – marcin_koss Apr 1 '16 at 14:15
  • Consider Postgres-XL as well. Needs more machines (in a cluster) to make use of it though. – ypercubeᵀᴹ Apr 6 '16 at 11:17

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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