database performance: FreeBSD vs Linux vs Solaris: Math
Non-threaded Math Performance
MySQL
Doing a simple row count, apart from the initial blip (counting the number of rows in an empty table),
there is no clear winner, Linux catches up as the size of the table is increased (lower is better):
Doing a column sum, Solaris and FreeBSD are twice as fast as Linux on the larger tables:
PostgreSQL
Doing a simple row count, Solaris and FreeBSD are twice as fast as Linux on the larger tables:
Doing a column sum gives very similar results:
