[buro9]

I agree that this is mainline code. I have a couple of multisite instances and I allow no plugins beyond Akismet purely to make upgrades and performance a no-brainer.

Yet in my pinboard I have this bookmarked: http://pento.net/2011/04/28/partitioning-the-wordpress-comme...

Yup, I had to partition the comments table.

I've been watching this too: http://wordpress.org/extend/plugins/postgresql-for-wordpress...

I'm willing to accept fractionally slower page loads, as for the most part they're cached heavily post-generation. I'd feel far more comfortable partitioning in Postgres not least because I'm far more familiar with it.