7 ms·

Fair point on the server being undersized. Stack is actually just Node

• IcePic 2mo ago
  In the 90s, people thought about the c10k problem, which is how to handle 10000 connections. In those days, this 2GB server would have been a dream to have and probably had moved the needle to 20k, 50k or whatever the limit is. You only get problems with 500 connections on a modern machine if you are really really bad at handling each request.
  • GroguMaster 2mo ago
    You are right, the server handled connections fine. The issue was a single unindexed correlated subquery blocking the entire PostgreSQL connection pool for 13 minutes. We live and learn.
    • IcePic 2mo ago
      Yes, did not mean to imply that everyone should know everything immediately, just that "the server was too small" feels a bit misguided. It might solve the problem to make the hw a real monster, but if you hit limits at 500 then I think one should look at the other parts of the equation. Glad you fixed it in the end.