As a followup to my previous MySQL bug post, I tried PostgreSQL and didn’t like it all that much. I found there was too much of a learning curve for someone who’s only really used MySQL to any great extent. It’s probably a better alternative for someone who is used to something like Oracle.
It seems that in gaining over 100,000 players, Kevan’s Urban Dead game has managed to find a bug in MySQL that causes corruption of indexes. Unfortunately no-one at MySQL AB is able to replicate the bug so it can’t be tracked down and fixed. More information can be found in the MySQL forum.