Ask HN: What is your “I don't care if this succeeds” project?

Re:Ask HN: What is your “I don't care if this succeeds” proj... by Charlieholtz on Friday February 11, 2022 @09:48AM (#30302062)

yeah so I'm seeing a ton of "(Postgrex.Error) FATAL 53300 (too_many_connections) remaining connection slots are reserved for non-replication superuser connections", which I'm guessing means the pool size is too small? Although I've tried upping that, CPU, and memory, and none have seemed to fix it. My devops skills still aren't great so if anyone has any ideas on how to help, let me know!

This might be a good opportunity to change the server to try out fly.io

[ Parent | on HN ]

Re:Ask HN: What is your “I don't care if this succeeds” proj... by dbetteridge on Friday February 11, 2022 @05:13PM (#30307646)

Pgbouncer is your friend for postgres dB's with lots of client connections.

Larger pool size only helps if they're freed up quicker than they are used.

[ Parent | on HN ]

Re:Ask HN: What is your “I don't care if this succeeds” proj... by LecroJS on Friday February 11, 2022 @06:17PM (#30308172)

Would you mind elaborating on the second point? Is this unique to larger pools? My inclination is that this would be true for pools of all sizes

[ Parent | on HN ]

Re:Ask HN: What is your “I don't care if this succeeds” proj... by psd1 on Saturday February 12, 2022 @07:11AM (#30312193)

I suspect GP meant: increasing pool size is only prolonging the inevitable

I've also observed on other DBs that you can increase the connection pool but it shifts the problem to other resources.

[ Parent | on HN ]

Re:Ask HN: What is your “I don't care if this succeeds” proj... by LecroJS on Saturday February 12, 2022 @08:01AM (#30312442)

Thanks for the clarification. Makes sense

[ Parent | on HN ]