What is connection pooling? Why is it critical for performance? How does HikariCP work?

Answer preview

Connection pooling keeps a warm set of database connections and lends them to application threads for the duration of a request, instead of opening a new TCP + auth + session for every HTTP call. Without it, PostgreSQL spends more CPU on connection setup than on queries.…