PostgreSQL and MySQL

Original sticker: Http://www.oschina.net/question/126398_61956?sort=time

Performance compared with less access, MySQL is better than PostgreSQL, but with higher access, PostgreSQL is much higher than MySQL.

MySQL uses multithreading: Multithreading does not require cross-process boundaries, program logic and control are simple, all threads can directly share memory and variables, etc., the total resources consumed by the thread is better than the process way.

So in the case of low-access MySQL is better than PostgreSQL, but the difference is not small, if the difference is too much, can only be said that the PostgreSQL thread run module algorithm efficiency is not good mysql.

However, under high access, because of the UNIX environment, the multi-process scheduling overhead is not significantly different than the multithreaded scheduling overhead (the Windows thread switchover is much faster than the process switching). Multiple processes are independent of each other, stability is much higher than multithreading, sub-process crashes are not closed, but multithreading one but one thread error, the entire program game over. Multithreading uses a process resource, and multithreading uses the resources of the entire system, so the multi-process can fully improve the efficiency of the system and the resource utilization of the system, so that it can not achieve the performance of multithreading.