Something I found while working on my dissertation (that's already known) is that performance is pretty poor for aggregate functions (MAX, MIN, AVG) - wish I'd known that before as I use a lot of them!

On a similarly sized dataset (although I'm yet to test on the same data) MySQL performed a lot better.