4 ms·
I'm a little confused by the pdf. Is it implying that the program is opening and closing a connection for each query? Is that normal these days?
by protomyth 10y ago
I'm a little confused by the pdf. Is it implying that the program is opening and closing a connection for each query? Is that normal these days?
- syncsynchalt 10y agoSome applications will indeed do that to guard against the server-side memory cost of thousands of postgres pool connections. It makes sense when queries are relatively rare. This was the solution that we used at MX Logic in the early years, before we moved to pgbouncer and went back to long-lived stateless connection pools.
- flooq 10y agoI thought it was more that they were opening a connection for several queries but doing other blocking IO tasks in between the queries, rather than just computation.