“The Postgres connection model relies on processes instead of threads.”
Every Postgres connection is a whole process, and idle ones still cost. For years the fix was a pooler bolted in front of the database. Postgres 14 makes thousands of connections cheaper in the engine itself. Nobody owns Postgres, and it still ships real fixes every year.