database performance: FreeBSD vs Linux vs Solaris: Insert
Non-threaded Insert Performance
MySQL
This test is a clear win for Solaris which is 40% faster of Linux and FreeBSD:
As the amount of initial data in the table is increased, Solaris increases its lead over FreeBSD and Linux:
(Another test batch produced almost identical results)
PostgreSQL
Overall, it looks like a win for Linux:
But as the amount of initial data is increased, the performance fluctuates a lot more and although Solaris comes out on top
with the biggest table (10000 rows), it is not always consistent:
