Do the connections not get closed? I'm using a cheap database on elephantSQL and get constant errors that I have too many connections. I'm currently allowed 10 connections on my plan.
Connections just seem to be sat there still open?
lukee48
All 2 comments
What exception are you getting? I assume that the application is concurrently processing requests with disabled pooling in the connection string. Is it?
YohDeadfall
on 7 Aug 2019
Do the connections not get closed?
That would be very expensive (opening and closing connections all the time), instead connections are pooled by default.
I'm currently allowed 10 connections on my plan.
The default maximum limit of pooled connections set to 100. You might want to drop that down to 10 and see if it makes things better.
See https://www.npgsql.org/doc/connection-string-parameters.html#pooling.
khellang
on 8 Aug 2019
Related issues
pgrm
路
4Comments
aaronhudon
路
3Comments
bugproof
路
4Comments
sebstr
路
4Comments
Drago95
路
3Comments
Most helpful comment
That would be very expensive (opening and closing connections all the time), instead connections are pooled by default.
The default maximum limit of pooled connections set to 100. You might want to drop that down to 10 and see if it makes things better.
See https://www.npgsql.org/doc/connection-string-parameters.html#pooling.