Database Connection Pooling: Why It Matters? Essential OS-Level Insights

Database connection pooling is a method to reduce costs associated with opening and closing connections by maintaining a pool of open connections. Learn WHY connection pooling is so important by seeing what happens at the operating system (OS) level when there's no connection pool between an application and a database.

0:00 Introduction
0:25 Watching OS processes created by Postgres
1:03 Using psql, confirming Postgres creates a process per connection
2:20 Starting an app, Postgres constantly opens and shuts processes
3:25 Enabling a client-side connection pool
4:15 Testing the workload with the connection pool

Curious to learn even more about databases? Follow me here:
Medium: medium.com/@magda7817
Twitter: twitter.com/denismagda