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 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 ]