database connection pooling optimizing performance

hey everyone, i've been thinking about database connection pooling lately. we all know its crucial for performance, but im curious about the best practices for setting it up. what are your go-to strategies for tuning pool sizes, handling timeouts, and ensuring efficient connection reuse without overwhelming the database? are there specific metrics you monitor to identify potential bottlenecks in your pooling strategy?