Thanks for the advice regarding Postgres.
I'm aware that there are many
issues with MySQL. But as with any tool, used appropriately, it works fine for this particular application. I perform analysis on the data and are much more dependent on small data size and raw speed than
transactional behavior. MySQL has proven ideal for this.