Postgres connection pooling is pretty much necessary in almost all cases, except when doing pretty low level connection management yourself.

Besides the old stalwart pgBouncer, Yandex recently released Odessey as well https://github.com/yandex/odyssey