>>2340>Did you check if those timeouts are actually preventing the locks or just killing the client-side connection?I had a similar nightmare with a legacy Django app where every single
Postgres query from the analytics bot was basically a sledgehammer. The connections would drop but the backend work just kept spinning in the dark for minutes. It's like when someone uses a bad kerning pair - it looks okay at a glance, but the underlying structure is totally broken and messy. I eventually had to move all that garbage stuff to a separate read-only instance because
killing the process wasn't enough to stop the resource spikes. OP, you definitely need to check your active pid list after those timeouts hit. If they're still hanging around, you're just leaving ghosts in your system.