Counting posts takes too long, has a tendency to cause timeouts on login

[codl]

LOG:  duration: 205203.988 ms  statement: SELECT count(*) AS count_1 
        FROM (SELECT posts.created_at AS posts_created_at, posts.updated_at AS posts_updated_at, posts.id AS posts_id, posts.author_id AS posts_author_id, posts.favourite AS posts_favourite, posts.has_media AS posts_has_media, posts.direct AS posts_direct, posts.favourites AS posts_favourites, posts.reblogs AS posts_reblogs, posts.is_reblog AS posts_is_reblog 
        FROM posts 
        WHERE 'mastodon:[email protected]' = posts.author_id) AS anon_1

I need to move the DB off of spinning rust at some point

[NoraCodes]

This (I think??) is making it impossible to log in - is there a workaround?

[codl]

@NoraCodes Not at the moment, sorry. But also see #511 which is more likely to be the current reason for your issue, have you tried again later?

[NoraCodes]

I tried 4 times at intervals of about 15 minutes. However I'm actually going to deploy forget on my own server so as not to load down yours, so it shouldn't be an issue (for me) going forward. Thanks!

…

On Sat, Aug 14, 2021, at 17:30, codl wrote: @NoraCodes <https://github.com/NoraCodes> Not at the moment, sorry. But also see #511 <#511> which is more likely to be the current reason for your issue, have you tried again later? — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#397 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAZDJ7IGZQOMU4R6RMQJHLTT44DC5ANCNFSM4XH4K63A>. Triage notifications on the go with GitHub Mobile for iOS <https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android <https://play.google.com/store/apps/details?id=com.github.android&utm_campaign=notification-email>.