Conversations may need index/query change
On one instance I have 12,000+ DMs in the database. I noticed using the Mast iOS app when reinstalling/adding my account again it was failing to load any Conversations, so I couldn't see my Direct Messages. I suspect a query was timing out and I was getting no data back. Wiping the data and rebuilding it with the
mix pleroma.database bump_all_conversations task fixed it, which might be due to the data being hot in memory. This has happened twice on this specific server.
Can we examine our queries and indexes for Conversations in case we are missing any optimizations?