Bad performance for accounts with many followers
Apparently, even with the recent changes related to query planning, postgres will still use a query plan that involves a sequential scan through the database for the profile pages of accounts that don't have many posts. This leads to rather bad performance for those accounts.
Edited by lain