2 ms·
Without broken formatting: > 1. The initial time to establish a connection is higher than would be ideal > 2. Each connection, even an idle one, has an overhe
by majewsky 7y ago
Without broken formatting:
> 1. The initial time to establish a connection is higher than would be ideal
> 2. Each connection, even an idle one, has an overhead of roughly 10 MB. For idle connections this is pretty much wasted space and most application frameworks grab a pool of connections accumulating quite a few idle connections.
> 3. The max number of connections you can push the system to is somewhere in hundreds to low thousand. Yes, it is possible to push PG further but it is not trivial.