This post contains some technical information that will be very interesting to other developers, but may not be so interesting to those that don’t work with databases.
For those of you that just want the nutshell:
We’ve switched to new database server software because we think the new software will be faster and store the same data while using less disk space (making our storage costs lower).
Now for the detailed explanation:
Back in August, we switched the FeedLounge database from MySQL’s MyISAM tables to InnoDB tables. This solved a number of problems that we were having with the MyISAM tables, but also introduced a number of other issues including slower performance on a number of queries (counting in particular). As we did more and more research into how to solve these problems, we decided that one promising solution would be to switch to a PostgreSQL database instead of a MySQL database altogether.
That is what w
