Great article that matches my experiences: running with max_connections=100000 is not an issue when you have more than enough ram, the problem is the idle connections that you are tempted to tolerate (after all, you've got lots of RAM, so why bother?) linearly decrease the TPS even if nothing is done<p>pgbouncer does help, but brings in unneeded complexity.<p>postgres 14 should offer an "alternate" port doing essentially what pgbouncer does, next to the regular port.<p>Typical usecase: a large fleet of IOT devices with a write-only access to a central database, feeding new data every second. No visibility of the current transactions is needed.