Summary
Is it possible to delete posts to get back under the 10,000 message limit in the Team edition?
Observed behavior
I had an automated webhook that went wild and sent about 40,000 messages in the span of a couple hours, which caused me to hit the 10,000 message limit and now I can’t see any posts older than today in any channel. I ran a command in my Postgres DB to mark the messages as deleted, but I haven’t actually removed any entries because I’m afraid of causing instability if I do. And so far, doing so doesn’t appear to have restored my past messages. Is there a safe way to do it, and would it actually restore my other messages? Or delete and recreate the channel? Here’s the command I ran:
UPDATE posts SET deleteat = (EXTRACT(EPOCH FROM NOW()) * 1000) WHERE channelid = 'Automation_Channel_ID' AND deleteat = 0;