Is our long international nightmare finally over? Is my server back up after scheduled maintenance? If your reading this, yes it is! All of our collective problems are solved!
@fastfinge Oof. Sounds like you should look into ways to make that be kinder to your database. Because yeah, otherwise it's gonna hurt. Sidekiq will stack processes in the queue until a connection frees up.
@quanin Oh, no, the postgresql database is fine. Connections are capped at 200 and reused. But in order to clear queues faster, we accept posts from everyone and just hold on to them until a database connection frees up, so we're not the bottleneck and everyone can clear their queues quicker.
@fastfinge Aha. I might have misread something you said, because it sounded a lot like it was hammering your DB and that was hammering your system load.
@quanin No, it was hammering the number of open TCPIP connections allowed by Linux. And that, thus, hammers load when you have hundreds of thousands of open sockets.