Multi-core CPU and mysql/postgresql?

Question

MySQL

I have two questions:
1) I found information on multithreading dated 2012, something may have changed:
a) does mysql use the record (insert queries) using the resources of all processor cores?
b) the same, but about postgresql
2) Which architecture solution is preferable, nosql or sql, with a constantly high load of insert queries?
3) And if Sql, then mysql or postgresql? As I understand it, it is necessary to horizontally scale the system using sharding?

Answer 1

Postgres spawns processes to execute queries, so under heavy load, it will automatically use all the cores. Muscle generates threads. For insertion, noSQL, such as Cassandra, is preferable, but the decision to use should not be made based on this indicator, because. it is easily raised by various methods.

Answer 2

postgresql seems to be butting heads with oracle. and the muscle is in the playoffs. about multi-core - when adding cores on a server, the processing speed increases linearly (according to my impression)