2 ms·
> I love Postgres, but lack of parallel query processing ... for some projects. It has surprisingly little effect on many workloads though - then engine is fai
by dspillett 10y ago
> I love Postgres, but lack of parallel query processing ... for some projects.
It has surprisingly little effect on many workloads though - then engine is fairly conservative on when it will use it too (and there are easy ways for you to accidentally make it not consider parallelism).
For many workloads you are often better off using the many CPU cores to run different queries than cooperate on a smaller number.
Data warehousing and "big data" are a place where this isn't the case though, and other features MS SQL Server has over PG and others shine here too: the column store indexes, in-memory processing, and so forth. And you get these in the free "express" editions too, as of 2016sp1, though that is only really useful for small projects and prototypes due to other limitations in that edition (10Gb/database, max 4 CPU cores & 1.5Gb RAM put to use per instance) so you'll be paying for standard edition at least for real work.