What is connection pooling in PostgreSQL?

connection pooling is an important concept in PostgreSQL. Understand its purpose, how it works, when to use it, and the tradeoffs it introduces before applying it in a production system.