logoalt Hacker News

gkbrkyesterday at 3:01 PM2 repliesview on HN

If it's designed well, your application also opens a pool of connections and re-uses them each time the code needs a DB connection.


Replies

mike_hearnyesterday at 4:21 PM

The issue is language ecosystems that don't use client side connection pooling because they're single threaded (node, Python). So scaling up the number of web server threads means scaling the number of Postgres processes, which are expensive.

aobdevyesterday at 4:00 PM

This solves the latency but not the overhead--you'll end up with a full pool of connections for each running instance of your application.

show 2 replies