Re: 20% performance drop on PostgreSQL 9.2 from kernel 3.5.3 to 3.6-rc5 on AMD chipsets - bisected

Andi Kleen
2012-09-17T14:39:51Z

> IIRC mysql does this properly and outperforms postgresql

Properly = futexes?

It depends on the MySQL engine. Last time I looked InnoDB
did use custom spinlocks too. Some of the other MySQL
engines seem to use adaptive pthread mutexes in glibc, but those
have their problems too.

In general unfortunately MySQL is not a single load, it's more
like a wide range of loads depending on the underlying storage engine.
PostgreSQL at least is more consistent in its problems.

-Andi