MySQL would most likely be sufficient to run a forum of this size. Slashdot.org gets huge numbers of hits a day and they are using mysql as their db.